Re: [SQL] Problems invoking psql. Help please.

[Michiel Lange]

That is indeed true. Also I see you do everything as root, try creating a new user especially for postgres databases. create a directory with root in /usr/loca/pgsql/ named data, or any other directory that is in $PGDATA. chown the directory to the postgres user, log in as the postgres user and try to initdb, postmaster (-i!) and connect... I think the problem lies here somewhere...

Michiel

At 02:13 20-11-2002 -0500, Tom Lane wrote:

Hugh Esco <[EMAIL PROTECTED]> writes:
>> biko:/usr/bin# ls -al | grep psql
>> lrwxrwxrwx    1 root     root           10 Oct 10 16:24 psql -> pg_wrapper

> This seems to say that Other users, like postgres, should be able to
> execute it.  I'm confused, here.

The permissions attached to a symbolic link are meaningless, in all Unix
variants I've dealt with.  You need to look at the permissions of the
linked-to object (here, pg_wrapper) instead...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly