Re: PostgreSQL Guard

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: PostgreSQL Guard
Дата
Msg-id CAKAnmmLpQSG7XSHiGG7eJvoy7TT8+qO39nVmMNOvO3GYekzw=w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Guard  (Jason Long <hack3rcon@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Riivo Kolka
Дата:
Сообщение: Orphan table files at data/base/
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Orphan table files at data/base/