Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 46D6F2E32EB for ; Sun, 13 Jan 2008 18:13:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50564-03 for ; Sun, 13 Jan 2008 18:13:42 -0400 (AST) Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.233]) by postgresql.org (Postfix) with ESMTP id 22D122E32ED for ; Sun, 13 Jan 2008 18:13:42 -0400 (AST) Received: by qb-out-0506.google.com with SMTP id o12so219541qba.17 for ; Sun, 13 Jan 2008 14:13:41 -0800 (PST) Received: by 10.64.249.20 with SMTP id w20mr12799748qbh.44.1200262420380; Sun, 13 Jan 2008 14:13:40 -0800 (PST) Received: by 10.35.107.16 with HTTP; Sun, 13 Jan 2008 14:13:40 -0800 (PST) Message-ID: <33632cf0801131413h3af5e2ddy908ff584d46dc4b8@mail.gmail.com> Date: Mon, 14 Jan 2008 03:43:40 +0530 From: "Vishal Mailinglist" To: "Suresh Gupta VG" Subject: Re: Need some info. Cc: pgsql-admin@postgresql.org In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0BC38B00@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6612_26278628.1200262420364" References: <3D5445983859B84B92669C0D883EA6FB0BC38B00@ZENMAILHQ1.ind.zensar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/141 X-Sequence-Number: 27915 ------=_Part_6612_26278628.1200262420364 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi , Before you do any thing like upgrade backup is the mantra - in plain sql format - File system base ( remember to shutdown postgresql before taking backup) - pg_dump Queries :- > > 1) Can we do rollback if required after complete installation?? > Yes you would be able to, make sure you overwrite all binaries of old PostgreSQL when upgrade , in case of rollback simply compile and overwrite binary. 3) If we do the installation in the other directory which doesn't > contain old version. Does it solve our problem > Yes that may help this way you may not have to do the file system backup. -- Regards, Vishal Kashyap. Need help visit http://help.vishal.net.in ------=_Part_6612_26278628.1200262420364 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi ,

Before you do any thing like upgrade backup is the mantra
  • in plain sql format
  • File system base ( remember to shutdown postgresql before taking backup)
  • pg_dump

Queries :-

1)       Can we do rollback if required after complete installation??


Yes you would be able to, make sure you overwrite all binaries of old PostgreSQL when upgrade , in case of rollback simply compile and overwrite binary.

3)       If we do the installation in the other directory which doesn't contain old version. Does it solve our problem


Yes that may help this way you may not have to do the file system backup.


--
Regards,
Vishal Kashyap.
Need help visit
http://help.vishal.net.in ------=_Part_6612_26278628.1200262420364--