Replicating an existing (huge) database

From: Srinivasa T N <seenutn(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Replicating an existing (huge) database
Date: 2022-11-28 10:17:05
Message-ID: CAFruNdeXBDzHvQGBPfvc+cbKKTq=WsJKTzdKYkhMpLsG3RtGdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2022-11-28 10:24:32 Re: Replicating an existing (huge) database
Previous Message Laurenz Albe 2022-11-28 07:53:15 Re: autovacuum hung on simple tables