pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMeaning of srsubstate values in pg_subscription_rel
2+ messages / 2 participants
[nested] [flat]
* Meaning of srsubstate values in pg_subscription_rel
@ 2019-05-22 23:36 Lev Kokotov <lev.kokotov@instacart.com>
0 siblings, 1 reply; 2+ messages in thread
From: Lev Kokotov @ 2019-05-22 23:36 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Meaning of srsubstate values in pg_subscription_rel
@ 2019-05-23 04:17 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Lev Kokotov <lev.kokotov@instacart.com>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2019-05-23 04:17 UTC (permalink / raw)
To: Lev Kokotov <lev.kokotov@instacart.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-05-23 04:17 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-05-22 23:36 Meaning of srsubstate values in pg_subscription_rel Lev Kokotov <lev.kokotov@instacart.com>
2019-05-23 04:17 ` Laurenz Albe <laurenz.albe@cybertec.at>
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