SV: [ic] Interchange and PostgreSQL

[Rick Eicher II]

On Wednesday 15 May 2002 02:22 am, Ulf Holt wrote:
> Hi Mike
>
> I don't know what your problems was with Postgresql, but now it's working
> for me. My main problem was that someone expected me to know how Postgresql
> is working, which I did not. The makecat script used root as the user for
> creating the database, and I just typed in postgres instead - this created
> the database and now I'm up and running (you must off cours have started
> postgresqld first). I guess user root does not exist as a Postgresql user
> and must be added with createuser (su -l postgres first).

IMHO it would be better to create a user for the catalog. So if the catalog is 
foundation, createuser foundation. Each catalog has it own user to connect to 
the database. You can fine tune the permission on a by user bases on the 
database server. This way you are not making connection to the database as 
the super user.

> I hope I don't treat you like an idiot - this telle more about my lack of
> experience with Linux than anything else.
>
> Cheers
>
> Ulf
>

Some thing to think about.

Rick Eicher II
www.pbol.net