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
