Re: postgres on a FreeBSD 4.5 box

From: Ken Guest <kguest(at)stockbyte(dot)com>
To: Gregory Wood <gregw(at)com-stock(dot)com>
Cc: 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:33:57
Message-ID: 3DC2ACF5.4020104@stockbyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gregory Wood wrote:

>>>I've installed postgres 7.1.3 on a FreeBSD 4.5 box using the ports
>>>system, I just can't seem to get it working.
>>>
>>>
>>>su-2.05a# /usr/local/etc/rc.d/010.pgsql.sh status
>>>pg_ctl: postmaster or postgres is not running
>>>su-2.05a# /usr/local/etc/rc.d/010.pgsql.sh start
>>>pg_ctl: postmaster does not start
>>>
>>>
>>Impossible to tell anything from this, since your script is hiding
>>whatever error message the postmaster might be emitting. Arrange
>>for the postmaster's stderr to go someplace useful (maybe into a
>>log file) and then see what it has to say.
>>
>>
>
>IIRC, the standard FreeBSD PostgreSQL ports script should log to
>/var/log/pgsql. Should be something useful in there.
>
>
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#

Any ideas of what I need to do?

k.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Davidson 2002-11-01 16:35:46 Re: [Fwd: [Re: Contribute link broken]]
Previous Message aagha@bigfoot.com 2002-11-01 16:33:35 DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error