[SAC] postgresql on adhoc VM is down

[Hamish]

Hi,

after standard "aptitude update && aptitude upgrade" on the adhoc VM, postgresql has not come back up.


"""
Get:10 http://debian.osuosl.org lenny/main postgresql-client-8.3 8.3.13-0lenny1 [1732kB]
Get:11 http://debian.osuosl.org lenny/main postgresql-8.3 8.3.13-0lenny1 [5442kB]
Get:12 http://debian.osuosl.org lenny/main postgresql 8.3.13-0lenny1 [279kB]  
...
Preparing to replace postgresql-client-8.3 8.3.12-0lenny1 (using .../postgresql-client-8.3_8.3.13-0lenny1_amd64.deb) ...
Unpacking replacement postgresql-client-8.3 ...
Preparing to replace postgresql-8.3 8.3.12-0lenny1 (using .../postgresql-8.3_8.3.13-0lenny1_amd64.deb) ...
Stopping PostgreSQL 8.3 database server: main.
Unpacking replacement postgresql-8.3 ...
Preparing to replace postgresql 8.3.12-0lenny1 (using .../postgresql_8.3.13-0lenny1_all.deb) ...
Unpacking replacement postgresql ...
...
Setting up postgresql-client-8.3 (8.3.13-0lenny1) ...
Setting up postgresql-8.3 (8.3.13-0lenny1) ...
Starting PostgreSQL 8.3 database server: mainThe PostgreSQL server failed to start. Please check the log output. failed!
 failed!
invoke-rc.d: initscript postgresql-8.3, action "start" failed.
dpkg: error processing postgresql-8.3 (--configure):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql:
 postgresql depends on postgresql-8.3; however:
  Package postgresql-8.3 is not configured yet.
dpkg: error processing postgresql (--configure):
 dependency problems - leaving unconfigured
...
Errors were encountered while processing:
 postgresql-8.3
 postgresql
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install.  Trying to recover:
Setting up postgresql-8.3 (8.3.13-0lenny1) ...
Starting PostgreSQL 8.3 database server: mainThe PostgreSQL server failed to start. Please check the log output: 2011-02-02 23:30:04 PST LOG: could not load root certificate file "root.crt": no SSL error reported 2011-02-02 23:30:04 PST DETAIL: Will not verify client certificates. 2011-02-02 23:30:04 PST LOG: could not bind IPv4 socket: Address already in use 2011-02-02 23:30:04 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2011-02-02 23:30:04 PST LOG: could not bind IPv6 socket: Address already in use 2011-02-02 23:30:04 PST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2011-02-02 23:30:04 PST WARNING: could not create listen socket for "localhost" 2011-02-02 23:30:04 PST FATAL: could not create any TCP/IP sockets failed!
 failed!
invoke-rc.d: initscript postgresql-8.3, action "start" failed.
dpkg: error processing postgresql-8.3 (--configure):
 subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of postgresql:
 postgresql depends on postgresql-8.3; however:
  Package postgresql-8.3 is not configured yet.
dpkg: error processing postgresql (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 postgresql-8.3
 postgresql
"""


no idea,
Hamish