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