Lev Kokotov wrote: > 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. Is the state "s" (which means "synchroniz*ed*", not "synchroniz*ing*") shown for all tables in the subscription? Do you see any pertinent log messages on the standby server? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
