Meaning of srsubstate values in pg_subscription_rel

Поиск
Список
Период
Сортировка
От Lev Kokotov
Тема Meaning of srsubstate values in pg_subscription_rel
Дата
Msg-id A7FB58FA-3C2F-4659-9621-C1329B60797F@instacart.com
обсуждение исходный текст
Ответы Re: Meaning of srsubstate values in pg_subscription_rel  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Mariel Cherkassky
Дата:
Сообщение: Re: pg_restore takes more time on creation of rules
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Meaning of srsubstate values in pg_subscription_rel