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

__________ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 5974 (20110322) __________

ESET NOD32 Antivirus ha comprobado este mensaje.

http://www.eset.com