0

I'm going to migrate a production PostgreSQL 12 database (~200GB) to another more powerful server. There are a bunch of partitioned tables, some without primary key (theoretically, it won't be a problem to temporarily add them if needed).

Is there any solution to migrate without or at least with the smallest downtime?

devaskim
  • 492
  • 3
  • 10
  • Use replication, that reduces the downtime to almost zero – Frank Heikens Aug 29 '23 at 17:57
  • @FrankHeikens I can't get the following. As long initial copying will be in progress, as much data shift will be. How standby server will make up it after initial copying will finish? – devaskim Aug 29 '23 at 18:14

0 Answers0