Postgres Pro
Downloads
Home   >   mailing lists

Re: /etc/init.d/postgres-8.4-openscg start problem - Mailing list pgsql-novice

From Francisco Leovey
Subject Re: /etc/init.d/postgres-8.4-openscg start problem
Date
Msg-id 115366.71853.qm@web39324.mail.mud.yahoo.com
Whole thread Raw
In response to Re: /etc/init.d/postgres-8.4-openscg start problem  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-novice
Tree view
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.kumar@enterprisedb.com> wrote:

From: Vibhor Kumar <vibhor.kumar@enterprisedb.com>
Subject: Re: [NOVICE] /etc/init.d/postgres-8.4-openscg start problem
To: "Leo" <fleovey@saij.jus.gov.ar>
Cc: pgsql-novice@postgresql.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.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com


pgsql-novice by date:

Previous
From: "Leo"
Date:
Subject: Re: /etc/init.d/postgres-8.4-openscg start problem
Next
From: Vibhor Kumar
Date:
Subject: Re: /etc/init.d/postgres-8.4-openscg start problem