Articles by dratone

• How To Easily Migrate A PostgreSQL Server With Minimal Downtime

  Author: dratone • Tags: other, debian • Comments: 5

  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... | view as pdf