Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 767C363315F for ; Wed, 18 Feb 2009 12:23:09 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60852-01-7 for ; Wed, 18 Feb 2009 12:22:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 02269633198 for ; Wed, 18 Feb 2009 12:22:54 -0400 (AST) Received: by locust.cns.vt.edu (Postfix, from userid 986) id D0D6C118DCA; Wed, 18 Feb 2009 11:22:50 -0500 (EST) Date: Wed, 18 Feb 2009 11:22:50 -0500 From: Ray Stell To: Isabella Ghiurea Cc: pgsql-admin@postgresql.org Subject: Re: Upgrade 8.3.6 issues Message-ID: <20090218162250.GB7812@cns.vt.edu> References: <499C32D5.2060003@nrc-cnrc.gc.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <499C32D5.2060003@nrc-cnrc.gc.ca> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/136 X-Sequence-Number: 31357 btw, no dump is required to flip from 8.3x to 8.3x, but testing is a good thing. check the postmaster.pid [postgresql@swallowtail alerts_oamp]$ cat postmaster.pid 2545 /var/database/pgsql/alerts_oamp 5478001 0 alerts_oamp]$ ps -ef | grep 2545 500 2545 1 0 Jan11 ? 00:00:29 /usr/local/pgsql833/bin/postgres -D /var/database/pgsql/alerts_oamp 500 2546 2545 0 Jan11 ? 00:00:00 postgres: logger process 500 2548 2545 0 Jan11 ? 00:00:00 postgres: writer process 500 2549 2545 0 Jan11 ? 00:00:00 postgres: wal writer process 500 2550 2545 0 Jan11 ? 00:00:00 postgres: autovacuum launcher process 500 2551 2545 0 Jan11 ? 00:00:02 postgres: stats collector process On Wed, Feb 18, 2009 at 08:09:57AM -0800, Isabella Ghiurea wrote: > > Hi All, > I'm testing for the first time a PG upgrade process, presently running > 8.3.4 and try to upgrade to 8.3.6. I have installed 8.3.6 in separate dir > - run pg_dumpall using the new PG 8.3.6 version > - shutdown the server > - create a new db cluster with 8.3.6 initdb > -copy pg_gba.conf and postgres.conf to 8.3.6 PG location > -Now I can't start the db server using the pg 8.3.6 version ., I'm using > same port # default . Here is my message: > > pg_ctl status > > pg_ctl: no server running > >0:bin$ pg_ctl start > server starting > postgres@cvodb0:bin$ 2009-02-18 08:00:59 PST::@:[16713]:LOG: could not > bind IPv6 socket: Address already in use > 2009-02-18 08:00:59 PST::@:[16713]:HINT: Is another postmaster already > running on port 5432? If not, wait a few seconds and retry. > 2009-02-18 08:00:59 PST::@:[16713]:LOG: could not bind IPv4 socket: > Address already in use > 2009-02-18 08:00:59 PST::@:[16713]:HINT: Is another postmaster already > running on port 5432? If not, wait a few seconds and retry. > 2009-02-18 08:00:59 PST::@:[16713]:FATAL: could not create any TCP/IP > sockets > pg_ctl status > pg_ctl: no server running > > What do I miss ? > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin