pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Need some info.
3+ messages / 3 participants
[nested] [flat]

* Need some info.
@ 2008-01-10 07:37 Suresh Gupta VG <suresh.g@zensar.com>
  2008-01-11 15:24 ` Re: Need some info. Andrew Sullivan <ajs@crankycanuck.ca>
  2008-01-13 22:13 ` Re: Need some info. Vishal Mailinglist <list@vishal.net.in>
  0 siblings, 2 replies; 3+ messages in thread

From: Suresh Gupta VG @ 2008-01-10 07:37 UTC (permalink / raw)
  To: pgsql-admin

Hi Team,

 

We are upgrading the pgsql from 7.4.2 to 8.2.5 on Solaris 9 Spark
machine, I had downloaded the sources also. I had gone through the
instalation documents too. I could not find the procedure to rollback
the new version, if the new version does not support our application. 

Queries :-

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

2)       Pls provide the link or related docs if any. Else is there any
alternative way to get back to old version after complete installation?

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

 

Pls advice on this.

Regards,

G. V. Suresh Gupta

------------------------------------------------------------------------
---------------------------------------------------------

Innovative Technology Solutions(ITS), Zensar Technologies 

Zensar Knowledge Park, Plot#5, MIDC IT Tower, 

Kharadi, Off Nagar Road, Pune - 411014

Landline :  +91-20-66453471           | +91-9890898688                 

Email     :   suresh.g@zensar.com    | website:  www.zensar.com
<http://www.zensar.com/; 

 

 

 

 

 

 



DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. 

Attachments:

image001.jpg (image/jpeg, 3.1K) download view image
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: Need some info.
  2008-01-10 07:37 Need some info. Suresh Gupta VG <suresh.g@zensar.com>
@ 2008-01-11 15:24 ` Andrew Sullivan <ajs@crankycanuck.ca>
  1 sibling, 0 replies; 3+ messages in thread

From: Andrew Sullivan @ 2008-01-11 15:24 UTC (permalink / raw)
  To: pgsql-admin

On Thu, Jan 10, 2008 at 01:07:09PM +0530, Suresh Gupta VG wrote:
> We are upgrading the pgsql from 7.4.2 to 8.2.5 on Solaris 9 Spark
> machine, I had downloaded the sources also. I had gone through the
> instalation documents too. I could not find the procedure to rollback
> the new version, if the new version does not support our application. 

This is a difficulty, yes.

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

Generally, major releases are binary incompatible.  If you find your upgrade
fails, you can of course continue to use your old installation (so don't
delete your old data directory!).  But if you've processed transactions in
the new system, they'll be lost to the old installation, and then you're
hosed.

What you _can_ do, however, is install Slony.  You might need to upgrade
your 7.4 version to do this -- the version you have is very old, and there
are some bugs that might affect Slony (I don't remember).  Not to worry --
that shouldn't be a big deal (it's not a dump and restore).  But it will
require some planning and such.  What you do, in this case, is install Slony
on 7.4, add the 8.2.x replica, and let it catch up.  When it's time to do
your upgrade, you do a switchover (not a failover) and cause the 8.2.x to
replicate to your 7.4.x installation.  Now transactions that happen in 8.2
will also appear in 7.4, and if something blows up, you can switch back.

This feature is an explicit design goal of Slony, and Afilias has used it in
production, so I can be confident it works.  But you need to do a lot of
planning and testing.  It isn't something to do in a couple days' time.

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

Sort of; see above.

A





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Need some info.
  2008-01-10 07:37 Need some info. Suresh Gupta VG <suresh.g@zensar.com>
@ 2008-01-13 22:13 ` Vishal Mailinglist <list@vishal.net.in>
  1 sibling, 0 replies; 3+ messages in thread

From: Vishal Mailinglist @ 2008-01-13 22:13 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: 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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-01-13 22:13 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-10 07:37 Need some info. Suresh Gupta VG <suresh.g@zensar.com>
2008-01-11 15:24 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-01-13 22:13 ` Vishal Mailinglist <list@vishal.net.in>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox