Search Postgresql Archives

Re: Replicating an existing (huge) database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux