Re: postgres on a FreeBSD 4.5 box

From: Ken Guest <kguest(at)stockbyte(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Gregory Wood <gregw(at)com-stock(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: postgres on a FreeBSD 4.5 box
Date: 2002-11-01 17:07:43
Message-ID: 3DC2B4DF.5020708@stockbyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

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

I took a look at the socket files in /tmp and they didn't have the
correct ownership. One quick chown -R
later and everythings fine.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Bakker 2002-11-01 17:34:47 Re: Questions on specifying table relationships
Previous Message Bruno Wolff III 2002-11-01 16:54:07 Re: FIFO Queue Problems