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

From: Francisco Leovey <fleovey(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: /etc/init.d/postgres-8.4-openscg start problem
Date: 2011-03-27 19:00:08
Message-ID: 52630.91775.qm@web39308.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- On Sun, 3/27/11, Francisco Leovey <fleovey(at)yahoo(dot)com> wrote:

Answering my own question .... changed the -w (wait) option on pg_ctl  to -W resolved the "problem" of pg_ctl start
 
Sombody in charge of maintaining pg_ctl should test it when the unix_socket_directory is changed from default

Thanks anyway
 

--- On Mon, 3/21/11, Leo <fleovey(at)saij(dot)jus(dot)gov(dot)ar> wrote:

From: Leo <fleovey(at)saij(dot)jus(dot)gov(dot)ar>
Subject: [NOVICE] /etc/init.d/postgres-8.4-openscg start problem
To: pgsql-novice(at)postgresql(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Marc-André Laverdière 2011-03-28 04:53:04 SSL root.crt not loading
Previous Message Francisco Leovey 2011-03-27 18:53:51 Re: /etc/init.d/postgres-8.4-openscg start problem