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

From Doug McNaught
Subject Re: postgres on a FreeBSD 4.5 box
Date
Msg-id m3r8e58cxg.fsf@varsoon.wireboard.com
Whole thread Raw
In response to postgres on a FreeBSD 4.5 box  (Ken Guest <kguest@stockbyte.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Ken Guest
Date:
Subject: Re: postgres on a FreeBSD 4.5 box
Next
From: Tom Lane
Date:
Subject: Re: postgres on a FreeBSD 4.5 box