From: DM <dm.aeqa@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
Date: Sun, 22 Feb 2009 02:32:34 -0800
Message-ID: <eae6a62a0902220232k2c6f64ban316be578332b5e2b@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10902220143l58823c17t60f635793586f54c@mail.gmail.com>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C0378F77E@egcrc-ex01.egcrc.org>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F77F@egcrc-ex01.egcrc.org>
<FE44E0D7EAD2ED4BB2165071DB8E328C0378F780@egcrc-ex01.egcrc.org>
<dcc563d10902220143l58823c17t60f635793586f54c@mail.gmail.com>
First make sure you stop the 8.3.3 / 8.3.6 server and then start 8.3.6
server and point the data path to 8.3.3 data path.
/usr/postgres/8.3.3/bin/pg_ctl -D /usr/postgres/8.3.3/data/pgsql8.3.3 stop
/usr/postgres/8.3.6/bin/postgres -i -D /usr/postgres/8.3.3/data/pgsql8.3.3
>logfile 2>&1 &
Enjoy
Thanks
Deepak Murthy
Fighting spirit spreads like fire from one person to another. A leader's
daring spirit will kindle flames of enthusiasm and inspire an entire
organization. - Daisaku Ikeda
Nam Myoho Renge Kyo - The Key to Unlock Your Highest Potential
(www.sgi-usa.org)
On Sun, Feb 22, 2009 at 1:43 AM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> > Hi,
> >
> > I am able to revert back to 8.3.3 system. Maybe
> > I can use 8.3.3 psql to read the dumpall output.
> > How can I direct the output to data directory of
> > 8.3.6 postgres?
>
> You don't have to dump and restore for a minor point update. Just
> stop your 8.3.3 and start 8.3.6 in the same data directory.
>
> --
> 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: dm.aeqa@gmail.com, scott.marlowe@gmail.com, tsakai@gallo.ucsf.edu
Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
In-Reply-To: <eae6a62a0902220232k2c6f64ban316be578332b5e2b@mail.gmail.com>
* 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