Re: PG migration policy - Mailing list pgsql-general

From Andy Colson
Subject Re: PG migration policy
Date
Msg-id 4F255EAC.1070406@squeakycode.net
Whole thread Raw
In response to PG migration policy  (Allan Kamau <kamauallan@gmail.com>)
List pgsql-general
On 01/29/2012 12:30 AM, Allan Kamau 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.
>
> Allan.
>

When our office moved location, and thus ISP's, we layed out a simple plan to keep our websites up at all time.  Our
plan,100% uptime while loosing no client updates. 

We layed out a time line, and on it what would happen and when.  We tried to come up with problems and solutions, etc.

Having a fallback wasn't really an option, because we were moving, its not like we could just give up and stay.  But we
hadsafety nets and backup options (including run a copy of the webserver VM from my house). 

DNS update was our biggest stumbling block, so we had to run two web servers concurrently, so that some people could
hitthe new and some could hit the old.  And updates would find their way to the right spots. 

-Andy

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: PG migration policy
Next
From: Scott Marlowe
Date:
Subject: Re: PG migration policy