LXer: How To Easily Migrate A PostgreSQL Server With Minimal Downtime
 

Published at LXer:

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...