Re: [GENERAL] PG migration policy

2012-01-29 Thread Allan Kamau
Thank you Sim, Bill, Andy, Scott and Tomas for all your suggestions. Indeed I have now learnt formulate such a document. The database we plan to move is used for research and it resides along side several other applications on the same hardware. The idea is to move the entire database cluster to a

Re: [GENERAL] PG migration policy

2012-01-29 Thread Tomas Vondra
On 29.1.2012 07:30, 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

Re: [GENERAL] PG migration policy

2012-01-29 Thread Scott Marlowe
On Sat, Jan 28, 2012 at 11:30 PM, 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 operati

Re: [GENERAL] PG migration policy

2012-01-29 Thread Andy Colson
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 m

Re: [GENERAL] PG migration policy

2012-01-29 Thread Bill Moran
In addition to all this, you will need to outline an actual plan for the migration itself: 1) Steps to migrate 2) Testing strategy to ensure the migration actually worked 3) Estimated time 3a) How much of that time is actual downtime 4) Fallback plan in case the migration fails For such document

Re: [GENERAL] PG migration policy

2012-01-29 Thread Sim Zacks
You are moving to a dedicated server for a reason, most probably performance. The intro section of the document should discuss the reasons you are moving and what you hope to accomplish. Hardware - The discuss the new platform that you are moving to, in terms of how it will perform better. Importa