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

From: Leo <fleovey@saij.jus.gov.ar>
Subject: [NOVICE] /etc/init.d/postgres-8.4-openscg start problem
To: pgsql-novice@postgresql.org
Date: Monday, March 21, 2011, 12:31 PM

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

 

= '/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