CODEWITHSUNDEEP
database-replicationpostgresql-12
Gabriele D'Onufrio
Gabriele D'Onufrio

Reputation: 424

Can I pause a replica on the receiver (subscriber) in postgres12?

Can I pause a replica on the receiver (subscriber) in postgres12?

just to alter some table structure and then Restart the replica

Upvotes: 2

Views: 850

Answers (1)

user330315
user330315

Reputation:

To pause a subscription, disable it:

alter subscription your_subscription_name disable;

To turn it on, just enable it again. It will pick up the transactions that were done in the meantime. As the publisher will keep the necessary WAL segments during that time, you should make sure, the subscription isn't disabled for too long to avoid flooding the file system of the publisher.

Upvotes: 4

Related Questions