Re: PG migration policy - Mailing list pgsql-general

From Scott Marlowe
Subject Re: PG migration policy
Date
Msg-id CAOR=d=0+fXCUXjkZb8PFfs9mHA3VxxUHrs2m3o2pjRS8gMsQ8w@mail.gmail.com
Whole thread Raw
In response to PG migration policy  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
On Sat, Jan 28, 2012 at 11:30 PM, Allan Kamau <kamauallan@gmail.com> wrote:
> Hi,
> This is definitely off topic, I apologize.
> We are planning to move our PostgreSQL installation from a shared
> server to a dedicated server. I have been given the responsibility of
> writing a migration policy document for this operation. This would be
> my first such document to put together,
> I am looking for pointers, samples and so on on which to build this
> document for our scenario.

Assuming you've tested ahead of time, the real question is how much
down time can you afford?

If you can afford hours or more of downtime, a dump and restore if the
easiest way.

If you need to keep your down time to a minimum, then look at using
some form of replication and switching from master to slave once the
slave is caught up.

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: PG migration policy
Next
From: Tomas Vondra
Date:
Subject: Re: PG migration policy