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 [email protected] -----Original Message----- From: Scott Marlowe [mailto:[email protected]] Sent: Sun 2/22/2009 1:43 AM To: Tena Sakai Cc: [email protected] 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 <[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.
