April 5, 2010

How To Easily Migrate A PostgreSQL Server With Minimal Downtime

How To Easily Migrate A PostgreSQL Server With Minimal Downtime

PostgreSQL is a great database server, but when your dataset is rather large, migrating a server by using pg_dump can be a rather long process. In this tutorial we will discuss a way to migrate a entire server with as little downtime as possible. To achieve this, we will be using the PostgreSQL built in features for PITR (Point in time recovery).

Read more at HowtoForge

Click Here!