PegoraroF10 wrote:
> 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 ?
For *logical* replication you can start with a "pg_dump --schema-only",
but for *physical* replication only a pg_basebackup will do.
Make sure that he tables are empty before you start logical replication.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
