From: | "Leo" <fleovey(at)saij(dot)jus(dot)gov(dot)ar> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Cc: | <vibhor(dot)kumar(at)enterprisedb(dot)com> |
Subject: | Re: /etc/init.d/postgres-8.4-openscg start problem |
Date: | 2011-03-22 14:54:24 |
Message-ID: | 000901cbe8a1$5f404fa0$232401c8@Leo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Vibhor Kumar | 2011-03-22 15:40:33 | Re: /etc/init.d/postgres-8.4-openscg start problem |
Previous Message | Francisco Leovey | 2011-03-22 14:48:47 | Re: /etc/init.d/postgres-8.4-openscg start problem |