Skip site navigation (1) Skip section navigation (2)

Re: Need some info.

From: "Vishal Mailinglist" <list(at)vishal(dot)net(dot)in>
To: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need some info.
Date: 2008-01-13 22:13:40
Message-ID: 33632cf0801131413h3af5e2ddy908ff584d46dc4b8@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-admin by date

Next:From: David WallDate: 2008-01-14 00:58:28
Subject: Re: large objects & space usage
Previous:From: Tom LaneDate: 2008-01-13 21:04:25
Subject: Re: large objects & space usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group