4

How To Easily Migrate A PostgreSQL Server With Minimal Downtime

view full story
linux-howto

http://howtoforge.com – 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). (HowTos)