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

From Ken Guest
Subject Re: postgres on a FreeBSD 4.5 box
Date
Msg-id 3DC2ACF5.4020104@stockbyte.com
Whole thread Raw
In response to postgres on a FreeBSD 4.5 box  (Ken Guest <kguest@stockbyte.com>)
Responses Re: postgres on a FreeBSD 4.5 box
List 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.


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Questions on specifying table relationships
Next
From: Doug McNaught
Date:
Subject: Re: postgres on a FreeBSD 4.5 box