Re: postgres on a FreeBSD 4.5 box

Ken Guest <kguest@stockbyte.com> writes:

> Gregory Wood wrote:
>
> No such beast as /var/log/pgsql.
> I did get this in a logfile though:
> "
> 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
> "
>
> Here's an ls -l
> su-2.05a# ls -l /usr/local/pgsql/data/global/pg_control
> -rw-------  1 pgsql  pgsql  8192 Nov  1 14:33
> /usr/local/pgsql/data/global/pg_control
> su-2.05a#

Is /usr/local/pgsql/data/global/pg_control readable by user 'pgsql'?
Does the startup script 'su' to that user before calling 'pg_ctl'?

It's possible that pg_control has the right permissions (looks OK from
the above) but one of the directories above it is locked down.

-Doug