From: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Upgrade 8.3.6 issues
Date: Wed, 18 Feb 2009 08:37:41 -0800
Message-ID: <499C3955.6000403@nrc-cnrc.gc.ca> (raw)
In-Reply-To: <20090218162250.GB7812@cns.vt.edu>
References: <499C32D5.2060003@nrc-cnrc.gc.ca>
<20090218162250.GB7812@cns.vt.edu>
Thank you , that worked!
Isabella
Ray Stell wrote:
>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: isabella.ghiurea@nrc-cnrc.gc.ca, stellr@cns.vt.edu
Subject: Re: Upgrade 8.3.6 issues
In-Reply-To: <499C3955.6000403@nrc-cnrc.gc.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox