[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Replicating an existing (huge) database
From:       Srinivasa T N <seenutn () gmail ! com>
Date:       2022-11-28 10:29:05
Message-ID: CAFruNdeXBDzHvQGBPfvc+cbKKTq=WsJKTzdKYkhMpLsG3RtGdA () mail ! gmail ! com
[Download RAW message or body]

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.

[Attachment #3 (text/html)]

<div dir="ltr">Hi All,<div>     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?</div><div><br></div><div>Regards,</div><div>Seenu.</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]