Thanks Joao, That is what I have done, but wanted to see if there was any other known potential risks. The fact about including an extra backup to go back if ever needed was underestimated, so I will consider it but not in my live servers.
Regards, Tony Fernandez -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joao Ferreira gmail Sent: Monday, November 10, 2008 10:36 AM To: pgsql-general Subject: Re: [GENERAL] Upgrading Postgres question On Wed, 2008-11-05 at 15:08 -0600, Tony Fernandez wrote: > Hello all, > > > > I am in the process of updating my DB on Postgres 8.1.11 to 8.3.4. I > also use Slony 1.2.14 for replication. > > > > Is there a safe path on how to accomplish this, please advice on what > steps I will need to consider. Bear in mind that I am planning to > skip from Postgres 8.1.x to 8.3.x and I use Slony to replicate my > production DB into two more boxes simultaneously. > I don't know about slony.... but, one way to do this is by (roughly): a) dump all contents of your pg with pg_dumpall b) install pg8.3 in a test server c) restore the dump into the test server (su postgres; psql -f my_dump); d) if all went well you can purge the 8.1 database from the disc or u can skip to the next step and install the new db in some alternative directory, in case you need to revert to pg8.1 latter. e) install 8.3 on the main server (maybe you will have to use initdb) f) restore the dump into the new 8.3 in the production server. This is how I do it :) Hope it fits your needs I also noticed some SQL parsing changes (like the need to explicitlly cast from text to numeric)... you shold try all your apps running against the test server before purging the old db the mais issue here is that, from 8.1 to 8.3 the underlying database files have changed format... so u need the dump/restore. u shld rd this: http://www.postgresql.org/docs/current/static/install-upgrading.html Joao > > > Thanks, > > > > Tony Fernandez > > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.9.0/1776 - Release Date: 11/8/2008 6:49 PM -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
