Обсуждение: Table and publisher/subscriber ownership

Поиск
Список
Период
Сортировка

Table and publisher/subscriber ownership

От
Siraj G
Дата:
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 

Re: Table and publisher/subscriber ownership

От
Siraj G
Дата:
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 

Re: Table and publisher/subscriber ownership

От
Adrian Klaver
Дата:
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