From: | "Leo" <fleovey(at)saij(dot)jus(dot)gov(dot)ar> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | /etc/init.d/postgres-8.4-openscg start problem |
Date: | 2011-03-21 15:31:20 |
Message-ID: | 000b01cbe7dd$074e6d00$232401c8@Leo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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.
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
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Vibhor Kumar | 2011-03-22 12:34:23 | Re: /etc/init.d/postgres-8.4-openscg start problem |
Previous Message | aaronenabs | 2011-03-20 21:40:57 | Re: Accessing dead rows within postgresql |