[SAC] postgresql on adhoc VM is down

[Markus Neteler]

Hi,

the same update is pending on the projectsVM, so far I did not upgrade
postgresql
there to not break it also there.

Markus

On Thu, Feb 3, 2011 at 8:41 AM, Hamish <hamish_b at yahoo.com> wrote:
> 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
> _______________________________________________
> Sac mailing list
> Sac at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/sac
>