Re: postgres on a FreeBSD 4.5 box - Mailing list pgsql-general

From Ken Guest
Subject Re: postgres on a FreeBSD 4.5 box
Date
Msg-id 3DC2B4DF.5020708@stockbyte.com
Whole thread Raw
In response to postgres on a FreeBSD 4.5 box  (Ken Guest <kguest@stockbyte.com>)
List pgsql-general
Tom Lane wrote:

>Ken Guest <kguest@stockbyte.com> writes:
>
>
>>postmaster does not find the database system.
>>        Expected to find it in the PGDATA directory "/usr/local/pgsql/data",
>>        but unable to open file
>>"/usr/local/pgsql/data/global/pg_control": Permission denied
>>
>>
>
>You've got a file permissions or ownership problem.  Offhand it looks
>like the files are owned by "pgsql" but you're probably trying to run
>the postmaster as "postgres".  You can either "chown -R"
>/usr/local/pgsql/data to postgres or tweak the start script to su to
>pgsql instead of postgres.
>
>

I took a look at the socket files in /tmp and they didn't have the
correct ownership. One quick chown -R
later and everythings fine.



pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: my.cnf to postgresql.conf Conversion
Next
From: Patrick Bakker
Date:
Subject: Re: Questions on specifying table relationships