Re: BUG #9416: Setting up postgresql-9.1 (9.1.12-0wheezy1) Fails Configuration

You are somewhat correct Tom,

I got it to work after finding out my system was unable to resolve
localhost.

Once it was able to do that the upgrade went through.

I'm off to find the package maintainer who assumes localhost resolves
successfully.

There should at least be a better error message.

Close this bug if you haven't already,

--PB--

->>>--Patrick---Boake---->

http://www.linkedin.com/in/netscr1be

http://www.google.com/profiles/pboake

A small sum can make a huge difference.
Join us on Kiva - http://kiva.org/invitedby/NetScr1be
Kiva Team: The Beech Trees <http://www.kiva.org/team/the_beech_trees>

On Mon, Mar 3, 2014 at 10:08 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> pboake(at)gmail(dot)com writes:
> > apt-get upgrade returns;
>
> > Setting up postgresql-9.1 (9.1.12-0wheezy1) ...
> > [....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL
> > server failed to start. Please check the log output: 2014-03-02 22:13:28
> EST
> > LOG: could not bind IPv4 socket: Cannot assign requested address
> 2014-03-02
> > 22:13:28 EST HINT: Is another postmaster already running on port 5432? If
> > not, wait a few seconds and retry. 2014-03-02 22:13:28 EST LOG: could not
> > bind IPv6 socket: Cannot assign requested address 2014-03-02 22:13:28 EST
> > HINT: Is another postmaster already running on port 5432? If not, wait a
> few
> > seconds and retry. 2014-03-02 22:1[FAILEST WARNING: could not create
> listen
> > socket for "localhost" 2014-03-02 22:13:28 EST FATAL: could not create
> any
> > TCP/IP sockets ... failed!
> > failed!
> > invoke-rc.d: initscript postgresql, action "start" failed.
>
> What that looks like is that the package's upgrade script forgot to stop
> the old postmaster version before trying to start the new one; or perhaps
> slightly more likely, failed to wait for the old postmaster to finish
> stopping.
>
> Either way, that would be a bug in the packaging, which you should take
> up with the Debian package maintainer, not with the upstream project.
>
> regards, tom lane
>