From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Lev Kokotov <lev.kokotov@instacart.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Meaning of srsubstate values in pg_subscription_rel
Date: Thu, 23 May 2019 06:17:27 +0200
Message-ID: <cf39d2bbb706c4e79eb9b31139b0fc42a7b829f2.camel@cybertec.at> (raw)
In-Reply-To: <A7FB58FA-3C2F-4659-9621-C1329B60797F@instacart.com>
References: <A7FB58FA-3C2F-4659-9621-C1329B60797F@instacart.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, lev.kokotov@instacart.com, pgsql-admin@lists.postgresql.org
Subject: Re: Meaning of srsubstate values in pg_subscription_rel
In-Reply-To: <cf39d2bbb706c4e79eb9b31139b0fc42a7b829f2.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox