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. Important aspects are memory, disk speed, RAID set up, cpu (not so much). Server Configuration Include: * Kernel compile options * params such as shmmax * file system chosen Postgresql Configuration: List each option you are going to change and values you are planing on using Backup strategy How often backups will be taken, where they go, if there is an offsite plan, how often restores are tested. HA strategy What are you plans if the server dies. You should also have a test server where you can test changes without affecting production. It should have the same configuration as the primary. On 01/29/2012 08: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. > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
