Re: Replicating an existing (huge) database

Поиск
Список
Период
Сортировка
От Torsten Förtsch
Тема Re: Replicating an existing (huge) database
Дата
Msg-id CAKkG4_=UrqbYZ6XGAu6Yc=CwmFnrDW2=io350PpEj9xLJvR6Og@mail.gmail.com
обсуждение исходный текст
Ответ на Replicating an existing (huge) database  (Srinivasa T N <seenutn@gmail.com>)
Список pgsql-general
You can set up wal archiving and set restore_command before you start the replica. Then you can use pg_basebackup with `-Xnone --no-slot`. Alternatively or in combination, use a quicker backup as Laurenz explained.

On Mon, Nov 28, 2022 at 11:17 AM Srinivasa T N <seenutn@gmail.com> wrote:
Hi All,
   I am using postgresql 12.  As part of streaming replication setup, I run pg_basebackup on the slave which copies the database from master to slave.  But the database is huge and it takes around 2 to 3 days for the pg_basebackup to finish.  When pg_basebackup is running, a huge number of wal files are generated on the master which occupies a lot of space (even though it is for 2-3 days, disk space is low).   Is there any other way to start replication without using pg_baseback?

Regards,
Seenu.

В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Replicating an existing (huge) database
Следующее
От: "yin.zhb@163.com"
Дата:
Сообщение: how to implement add using upsert and trigger?