pg_basebackup or dump for starting replication process

From: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_basebackup or dump for starting replication process
Date: 2018-04-05 15:45:44
Message-ID: 1522943144800-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

For replication purposes only, there are any difference between pg_basebackup
or dump to copy data from Master to Slave ?
On Docs is written that pg_basebackup can be used both for point-in-time
recovery and as the starting point for a log shipping or streaming
replication standby servers.

We are using just Dump, there are any caveat of using it for logical
replication ?

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2018-04-05 15:52:38 Re: [PATCH] Logical decoding of TRUNCATE
Previous Message Tom Lane 2018-04-05 15:37:01 Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100