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

Replication for migration

From: Martin Spinassi <martins(dot)listz(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Replication for migration
Date: 2009-05-14 13:57:26
Message-ID: 1242309446.3314.59.camel@kr0sty.livra.local (view raw or flat)
Thread:
Lists: pgsql-admin
Hi list!

I've to do a migration of postgresql from version 8.2 to 8.3 in one
server. The problem I see here is, to avoid data loss (people still
using the web site that uses postgres), I'll need to stop postgres 8.2,
make a pg_dumpall, and then restore that information in 8.3.
Taking some considerations, like database size, server, etc. I estimate
that it will be at least 30 minutes of downtime, and that's pretty much
time.

I've thinking in the possibility of doing some kind of master/slave with
both versions (I must change the default port in one of them, as
everything must happen on a single machine), and find some useful links
like:

http://wiki.postgresql.org/wiki/Replication%2C_Clustering%
2C_and_Connection_Pooling
http://momjian.us/main/writings/pgsql/replication.pdf


I'd love to read some experiences or advices, since I haven't done it
before. Also if you have some link o document that you think I must
read, it'll be welcomed.


Thanks to all.


Martín


Responses

pgsql-admin by date

Next:From: Kenneth MarshallDate: 2009-05-14 13:59:40
Subject: Re: Replication for migration
Previous:From: S ArvindDate: 2009-05-14 09:27:16
Subject: pg_top problem

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