Re: Non-superuser subscription owners

Поиск
Список
Период
Сортировка
Искать
От
Mark Dilger
Тема
Re: Non-superuser subscription owners
Дата
Msg-id
6ADE0BED-0B46-4BF0-AEDC-0D2D08648945@enterprisedb.com
Ответ на
Список
Дерево обсуждения
Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Ronan Dunklau <ronan.dunklau@aiven.io>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jacob Champion <jchampion@timescale.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Jacob Champion <jchampion@timescale.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jacob Champion <jchampion@timescale.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>
Re: Non-superuser subscription owners Jacob Champion <jchampion@timescale.com>
postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Stephen Frost <sfrost@snowman.net>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Jacob Champion <jchampion@timescale.com>
Re: postgres_fdw, dblink, and CREATE SUBSCRIPTION security Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners vignesh C <vignesh21@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
RE: Non-superuser subscription owners "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Alexander Lakhin <exclusion@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
RE: Non-superuser subscription owners "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
RE: Non-superuser subscription owners "Zhijie Hou (Fujitsu)" <houzj.fnst@fujitsu.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
RE: Non-superuser subscription owners "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Jeff Davis <pgsql@j-davis.com>
Re: sandboxing untrusted code Jeff Davis <pgsql@j-davis.com>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Jeff Davis <pgsql@j-davis.com>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Jeff Davis <pgsql@j-davis.com>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Tom Lane <tgl@sss.pgh.pa.us>
Re: sandboxing untrusted code Andres Freund <andres@anarazel.de>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Jacob Champion <jacob.champion@enterprisedb.com>
Re: sandboxing untrusted code Robert Haas <robertmhaas@gmail.com>
Re: sandboxing untrusted code Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Stephen Frost <sfrost@snowman.net>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Stephen Frost <sfrost@snowman.net>
Re: Non-superuser subscription owners Stephen Frost <sfrost@snowman.net>
Re: Non-superuser subscription owners Stephen Frost <sfrost@snowman.net>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Stephen Frost <sfrost@snowman.net>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Joe Conway <mail@joeconway.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Andres Freund <andres@anarazel.de>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Tom Lane <tgl@sss.pgh.pa.us>
Re: Non-superuser subscription owners Tom Lane <tgl@sss.pgh.pa.us>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Tom Lane <tgl@sss.pgh.pa.us>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Robert Haas <robertmhaas@gmail.com>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Jeff Davis <pgsql@j-davis.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Amit Kapila <amit.kapila16@gmail.com>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>
Re: Non-superuser subscription owners Mark Dilger <mark.dilger@enterprisedb.com>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>
Re: Non-superuser subscription owners Andrew Dunstan <andrew@dunslane.net>


> On Nov 1, 2021, at 10:58 AM, Mark Dilger  wrote:
> 
> ALTER SUBSCRIPTION..[ENABLE | DISABLE] do not synchronously start or stop subscription workers.  The ALTER command updates the catalog's subenabled field, but workers only lazily respond to that.  Disabling and enabling the subscription as part of the OWNER TO would not reliably accomplish anything.

Having discussed this with Andrew off-list, we've concluded that updating the documentation for logical replication to make this point more clear is probably sufficient, but I wonder if anyone thinks otherwise?

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company





В списке pgsql-hackers по дате отправления
От: David Zhang
Дата:
FAQ