Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

Of course, Deepak!

I had made an alias for "pg_ctl start ..." and always
had -D setting as /usr/local/pgsql/data. I have been
relying on this alias so much, I completely forgot
that's how actually it gets done.

Thank you.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: DM [mailto:dm(dot)aeqa(at)gmail(dot)com]
Sent: Sun 2/22/2009 2:32 AM
To: Scott Marlowe
Cc: Tena Sakai; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6

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(dot)marlowe(at)gmail(dot)com>wrote:

> On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>