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

From Tom Lane
Subject Re: postgres on a FreeBSD 4.5 box
Date
Msg-id 26766.1036168793@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres on a FreeBSD 4.5 box  (Ken Guest <kguest@stockbyte.com>)
List pgsql-general
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: postgres on a FreeBSD 4.5 box
Next
From: Ken Guest
Date:
Subject: Re: postgres on a FreeBSD 4.5 box