Thread: /etc/init.d/postgres-8.4-openscg start problem
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
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.
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
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
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
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:
|
__________ 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
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:
|
On Mar 22, 2011, at 8:24 PM, Leo wrote: > 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' - Ihad to add a mkdir on the /etc/init.d/postgres-8.4-openscg > > Please check this out - thanks > Its of OpenSCG installer. I have tried on RHEL. Seems to me working. However, I would recommend to contact OpenSCG. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@enterprisedb.com Blog:http://vibhork.blogspot.com
Answering my own question .... changed the -w (wait) option on pg_ctl to -W resolved the "problem" 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@saij.jus.gov.ar> wrote:
|
--- On Sun, 3/27/11, Francisco Leovey <fleovey@yahoo.com> wrote:
|