Re: Table and publisher/subscriber ownership

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Table and publisher/subscriber ownership
Date: 2026-04-29 17:41:33
Message-ID: 05c6fa57-903f-40d6-ba7b-2b48b253245d@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/29/26 1:16 AM, Siraj G wrote:
> Hello Experts!
>
> Question is on the pglogical replication.
> Do I have to have the tables and publisher/subscriber to be owned by a
> single user, on both the source and/or target sides?

See here:

https://www.postgresql.org/docs/current/logical-replication-security.html
>
> Regards
> Siraj
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Magoffin 2026-04-29 23:07:14 Confirmation on concurrent SELECT FOR UPDATE with ON CONFLICT DO NOTHING
Previous Message Andres Freund 2026-04-29 12:10:17 Re: Support logical replication of DDLs, take2