Horton
Menu

Thread

  1. Table and publisher/subscriber ownership

    Siraj G <tosiraj.g@gmail.com> — 2026-04-29T08:16:09Z

    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?

Regards
Siraj

  2. Re: Table and publisher/subscriber ownership

    Siraj G <tosiraj.g@gmail.com> — 2026-04-29T09:04:49Z

    The version of postgresql is 16.8 and it is a managed SQL in GCP.

Regards
Siraj

On Wed, Apr 29, 2026 at 1:46 PM Siraj G <tosiraj.g@gmail.com> 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?
>
> Regards
> Siraj
>
>

  3. Re: Table and publisher/subscriber ownership

    Adrian Klaver <adrian.klaver@aklaver.com> — 2026-04-29T17:41:33Z

    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.klaver@aklaver.com