Re: PostgreSQL Guard - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: PostgreSQL Guard
Date
Msg-id CAKAnmmLpQSG7XSHiGG7eJvoy7TT8+qO39nVmMNOvO3GYekzw=w@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Guard  (Jason Long <hack3rcon@yahoo.com>)
List pgsql-general
On Tue, Feb 27, 2024 at 3:48 PM Jason Long <hack3rcon@yahoo.com> wrote:
Suppose you want to transfer the database of a website like Amazon.com to a new server and delete the old one. Many users are buying and selling on this website at the same time and it is not possible to turn off the server. What do you do to move a database to another server?

If we assume your question is "how can we migrate to a new system while keeping the old one up and running to minimize downtime?" the answer is logical replication.


Cheers,
Greg

pgsql-general by date:

Previous
From: Riivo Kolka
Date:
Subject: Orphan table files at data/base/
Next
From: Laurenz Albe
Date:
Subject: Re: Orphan table files at data/base/