Issue with PostgreSQL install

[treaves]

Hello everyone. I just installed Serendiity on one of my servers. This server is used to do virtual hosting, mainly for my friends. I use PostgreSQL, and was very pleased to see it support.

I went through the install process for install1, and everything went flawlessly. I then created install2 and install3. Each of these installs is a seperate file structure; I don't need to match disk space. I do however like to keep my databases clean, and chose to use one database and one database user. I figured this would be easy, as the install process asks what prefix to use for database objects.

When I created the second install, I got a few errors about the database setup. It complaind that date_idx and one or two more already existed. The tables and sequences were created, so I decided to go ahead with the third install. Same errors (of course).

The installs all seem to function properly. Is this going to be an issue? Is there any reason that the indexes did not appear to use the same prefix as the tables and sequences? Should I change my install?

Thanks!

[garvinhicking]

Hi!

The problem is that pgsql has a kind of wicked index management which does not allow unique index names per table but rather per database. To stay compatible with other RDBMS we did not abstract the indexes with dbPrefix names.

Thus, I recommend to use one DB per install on postgreSQL. Without the indices and sequences you will definitely run into problems; if not usability problems, at least performance issues.

Regards,
Garvin

[silverfields1]

So should I re-install all three, or is simply redoing the last to O.K.? In other words, if I remove the tables for the second two, will the first ones index be O.K?

[garvinhicking]

Yes, the first install should work as expected, so you only need to redo the last.


Regards,
Garvin