Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 77E4B63316A for ; Wed, 18 Feb 2009 12:11:17 -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 48190-06 for ; Wed, 18 Feb 2009 12:10:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenexf2.nrc.ca (nrccenexf2.nrc.ca [132.246.15.83]) by mail.postgresql.org (Postfix) with ESMTP id 86DF0633194 for ; Wed, 18 Feb 2009 12:10:04 -0400 (AST) Received: from nrccenexf1.nrc.ca ([132.246.15.80]) by nrccenexf2.nrc.ca with Microsoft SMTPSVC(6.0.3790.3959); Wed, 18 Feb 2009 11:09:59 -0500 Received: from [192.168.11.209] ([132.246.15.68]) by nrccenexf1.nrc.ca over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Wed, 18 Feb 2009 11:09:58 -0500 Message-ID: <499C32D5.2060003@nrc-cnrc.gc.ca> Date: Wed, 18 Feb 2009 08:09:57 -0800 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Upgrade 8.3.6 issues Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 18 Feb 2009 16:09:58.0845 (UTC) FILETIME=[58B23ED0:01C991E3] 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/135 X-Sequence-Number: 31356 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 ?