Обсуждение: Meaning of srsubstate values in pg_subscription_rel

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
Postgresdoing in each state? 

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

Thank you!

Best,
Lev

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