I have a Postgresql Database on my Centos, I use barman to backup my database, my question is that is it possible to migrate my database to another server without downtime? I know some solutions with small downtime with pg_start_backup(), barman also can handle it, but is there anyway to do it without down time? And one more question is, what is the best way to migrate it?
2
-
Version of Postgres?– ypercubeᵀᴹCommented Jul 27, 2016 at 16:06
-
The Postgresql version is 9.4– MaironCommented Aug 5, 2016 at 13:13
Add a comment
|
1 Answer
If you need to migrate to the same version of postgres, then you can setup slave of your db on new server with streaming replication and then just promote it to master. There will be no downtime while doing pg_basebackup, maybe just some load on disks and network caused by your whole cluster moving to new server.
