Skip site navigation (1) Skip section navigation (2)

/etc/init.d/postgres-8.4-openscg start problem

From: "Leo" <fleovey(at)saij(dot)jus(dot)gov(dot)ar>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: /etc/init.d/postgres-8.4-openscg start problem
Date: 2011-03-21 15:31:20
Message-ID: 000b01cbe7dd$074e6d00$232401c8@Leo (view raw or flat)
Thread:
Lists: pgsql-novice
LINUX UBUNTU 10.10 new installation
I installed Postgres 8.4.7 using the openscg distribution packages/postgres-8.4.7-1.i386.openscg.deb 

The first problem was that the unix_socket_directory assumes '/tmp' 
DBD:Pg will not connect on /tmp so I had to change in postgresql.conf 

unix_socket_directory = '/var/run/postgresql'

Now DBD:pg connects - (had to adjust Webmin also)

However  after changing the socket dir, the /etc/init.d/postgres-8.4-openscg start command says

Starting PostgreSQL 8.4: 
waiting for server to start...............................................................could not start server
The PostgreSQL server start seems to have some problems, please see logs for details.

Log shows:

LOG:  database system was shut down at 2011-03-21 12:18:24 CDT
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

So all is running OK but the pg_ctl is not aware of this. 
I tried passing it the -k "/var/run/postgresql" option but that did not solve the problem

Please indicate a fix - thank you




__________ InformaciĆ³n de ESET NOD32 Antivirus, versiĆ³n de la base de firmas de virus 5970 (20110321) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com

Responses

pgsql-novice by date

Next:From: Vibhor KumarDate: 2011-03-22 12:34:23
Subject: Re: /etc/init.d/postgres-8.4-openscg start problem
Previous:From: aaronenabsDate: 2011-03-20 21:40:57
Subject: Re: Accessing dead rows within postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group