Meaning of srsubstate values in pg_subscription_rel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

We are subscribing to a publication with multiple tables. What would cause a subscription state to stay in “synchronizing” (`s`) and not move into “replicating” (`r`) during logical replication? I’m querying the `pg_subscription_rel` view.
Also, what is the meaning of each state (i.e. initialize, synchronized, data is being copied, and ready); what is Postgres doing in each state?

I’m using https://www.postgresql.org/docs/10/catalog-pg-subscription-rel.html as reference.

Thank you!

Best,
Lev





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux