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

Sorry, wrong answer.
Postgres was NOT running - maybe I was not clear
 
Editing postgres-8.4-openscg , I changed the -w (wait option on pg_ctl) to -W  and now it behaves the same as when unix_socket_directory  had no value in postgresql.conf
 
So it is clear that pg_ctl is waiting for some event that is not there when the socket dirrectory is modified.
 
Try it yourself, put a value on  unix_socket_directory  and you will see what I am talking about
 
BTW  the /etc/init.d/postgres-8.4-openscg is also wrong :  it fails to create the directory  '/var/run/postgresql' - I had to add a mkdir on the  /etc/init.d/postgres-8.4-openscg
 
Please check this out - thanks
 
--- On Tue, 3/22/11, Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> wrote:

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
Subject: Re: [NOVICE] /etc/init.d/postgres-8.4-openscg start problem
To: "Leo" <fleovey(at)saij(dot)jus(dot)gov(dot)ar>
Cc: pgsql-novice(at)postgresql(dot)org
Date: Tuesday, March 22, 2011, 9:34 AM

On Mar 21, 2011, at 9:01 PM, Leo wrote:

> 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.
> 

Reason: PostgreSQL is running and you are using Start Option.

Try:
./postgres-9.0-openscg restart

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com