Many thanks, Scott.
> Just stop your 8.3.3 and start 8.3.6 in the same data directory.
My set up is that I have a fair size partition named /pgsql.
In it, I have subdirectories such as 830, 833, and 836. As
I move from one rev to another, I basically make a link from
that directory (in my latest case, 836) to /usr/local/pgsql.
In the end, I just made a symbolic link from /pgsql/833/data
to /usr/local/pgsql/data. Is there any better way of achiving
the same thing?
I am running tests and so far it seems to work fine. I will
check back tomorrow and maybe I can give a report as to how
all this turn out.
BTW, I fixed work_mem back to 512MB.
Many thank you for your kindness and guidance.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
Sent: Sun 2/22/2009 1:43 AM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6
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.