PostgreSQL DBA

Logical Replication & Data Movement

Question

Publication versus subscription: what does each define, and when is each administered?

Answer

A publication defines a publisher-side set of table changes. A subscription defines the subscriber-side connection and selected publications. Administer publications to change what is offered; administer subscriptions to control receipt and application.

This is 6 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples