How To Set Up Logical Replication with PostgreSQL 10 on Ubuntu

How To Set Up Logical Replication with PostgreSQL 10 on Ubuntu postgres delete replication slot A limitation of the PostgreSQL implementation is that replication slots are not cluster-aware: a replication slot exists solely on the instance postgres replication slot With regards to replication slots, they are used to tell the master not to remove old + new WAL records from pg_xlog until the standby server

postgres replication slot Replication slots are used to safeguard against the premature deletion of WAL segments before they have been applied by the standby server, thus

postgres create replication slot Replication slots were introduced in PostgreSQL to help ensure a primary PostgreSQL instance does not remove WAL files before a replica has delete all data on the replica and pull it from the leader): root@my-postgres-0:homepostgres# patronictl reinit my-postgres my-postgres-1