| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: SUBSCRIPTIONS and pg_upgrade |
| Date: | 2017-02-17 22:19:12 |
| Message-ID: | 26c1bd53-0703-b557-f3a8-710a2d04cdad@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2/17/17 09:33, Stephen Frost wrote:
>> One reason is that pg_subscription is only readable by a superuser, so
>> we can't even dump them unless we're superuser.
> Sure, but that's true of roles and other things.. On a system with RLS,
> likely only the database superuser can actually read everything.
There are some concurrent discussions about getting a list of
subscriptions without having superuser. Once that is resolved, we'll
likely have more options here, such as dumping only subscriptions you
are owner of or something like that.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2017-02-17 22:21:41 | Re: SUBSCRIPTIONS and pg_upgrade |
| Previous Message | Tom Lane | 2017-02-17 21:31:57 | Re: pg_recvlogical.c doesn't build with --disable-integer-datetimes |