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

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(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Sun 2/22/2009 1:43 AM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)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(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.