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 [email protected] -----Original Message----- From: DM [mailto:[email protected]] Sent: Sun 2/22/2009 2:32 AM To: Scott Marlowe Cc: Tena Sakai; [email protected] 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 <[email protected]>wrote: > On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
