Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id E2212632DE8 for ; Sun, 22 Feb 2009 06:32:44 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39211-08 for ; Sun, 22 Feb 2009 06:32:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.174]) by mail.postgresql.org (Postfix) with ESMTP id BB58B63231C for ; Sun, 22 Feb 2009 06:32:36 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 23so1913235wfg.28 for ; Sun, 22 Feb 2009 02:32:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=S5W59gg+S5kc7HEYFGzO2NnRFABqCEYg0a2SohMKyDc=; b=f3t2pEFwG0SdEJVu/FZxNI9Q+M5EWhUvA5jw4R5OkIIEJrq+1YEGIAoy2ausd8BiUk 44plVe5wcSaQ+3FOgO1B+9L7AByVGZuyZJ31142ItviNncI0ndY186m2BQDMiGMgVd2J MsOmSXIFJDgkW9/+E5X+ccXhuFHgzbimo1eUk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=XTFPU9CGLc8LohkKIzBf8ki6HlUmudVi2DCDY7NuWvk11YGaTSy0FSq3loVBG6ljch yckItlyDOOUret6s+y1ASw+hUiehtXL7SKEy07TWtT+20vqgbkXj7Mq+vSdhMwG4Cz2o M7KNO1SvX9mYHf8eMaeT9F0blqqQ87JQl5pXY= MIME-Version: 1.0 Received: by 10.142.234.16 with SMTP id g16mr1385785wfh.264.1235298754464; Sun, 22 Feb 2009 02:32:34 -0800 (PST) In-Reply-To: References: Date: Sun, 22 Feb 2009 02:32:34 -0800 Message-ID: Subject: Re: trouble restoring data from postgres 8.3.3 to freshly installed 8.3.6 From: DM To: Scott Marlowe Cc: Tena Sakai , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd24262738c7d04637f671d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200902/183 X-Sequence-Number: 31404 --000e0cd24262738c7d04637f671d Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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 wrote: > On Sun, Feb 22, 2009 at 2:32 AM, Tena Sakai 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > --000e0cd24262738c7d04637f671d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable First make sure you stop the 8.3.3 / 8.3.6 server and then start 8.3.6 serv= er and point the data path to 8.3.3 data path.

/usr/postgres/8.3.3/b= in/pg_ctl -D  /usr/postgres/8.3.3/data/pgsql8.3.3 stop

/usr/pos= tgres/8.3.6/bin/postgres -i -D /usr/postgres/8.3.3/data/pgsql8.3.3 >logf= ile 2>&1 &

Enjoy

Thanks
Deepak Murthy

Fighting spirit spreads like fire from one person to another. A leader= 9;s daring spirit will kindle flames of enthusiasm and inspire an entire or= ganization. - 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 &l= t;scott.marlowe@gmail.com>= ; wrote:
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. &nbs= p;Just
stop your 8.3.3 and start 8.3.6 in the same data directory.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--000e0cd24262738c7d04637f671d--