Re: postgres on a FreeBSD 4.5 box

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Ken Guest <kguest(at)stockbyte(dot)com>
Cc: Gregory Wood <gregw(at)com-stock(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres on a FreeBSD 4.5 box
Date: 2002-11-01 16:36:27
Message-ID: m3r8e58cxg.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ken Guest <kguest(at)stockbyte(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-01 16:39:53 Re: postgres on a FreeBSD 4.5 box
Previous Message Geoff Davidson 2002-11-01 16:35:46 Re: [Fwd: [Re: Contribute link broken]]