Re: Need some info. - Mailing list pgsql-admin

From Vishal Mailinglist
Subject Re: Need some info.
Date
Msg-id 33632cf0801131413h3af5e2ddy908ff584d46dc4b8@mail.gmail.com
Whole thread Raw
In response to Need some info.  ("Suresh Gupta VG" <suresh.g@zensar.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: large objects & space usage
Next
From: David Wall
Date:
Subject: Re: large objects & space usage