Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 41B60475B8E for ; Wed, 20 Nov 2002 02:40:19 -0500 (EST) Received: from minas.demon.nl (minas-2.demon.nl [212.238.194.105]) by postgresql.org (Postfix) with ESMTP id DFB1E475A71 for ; Wed, 20 Nov 2002 02:40:17 -0500 (EST) Received: from depastor.minas.demon.nl (minas.pastoraat [192.168.1.1]) by minas.demon.nl (8.11.4/8.11.4) with ESMTP id gAKG1ZU02389; Wed, 20 Nov 2002 17:01:35 +0100 Message-Id: <5.1.0.14.0.20021120083656.00b2c068@192.168.1.3> X-Sender: michiel@192.168.1.3 X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Wed, 20 Nov 2002 08:40:11 +0100 To: Tom Lane From: Michiel Lange Subject: Re: Problems invoking psql. Help please. Cc: Hugh Esco , pgsql-sql@postgresql.org In-Reply-To: <29178.1037776397@sss.pgh.pa.us> References: <5.1.0.14.0.20021120015333.04220570@petra.cagreens.org> <5.1.0.14.0.20021120015333.04220570@petra.cagreens.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/296 X-Sequence-Number: 10438 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 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 majordomo@postgresql.org)