postgres.email
❮

Table and publisher/subscriber ownership

  • Jump to comment-1
    Siraj G<tosiraj.g@gmail.com>
    Apr 29, 2026, 8:16 AM UTC
    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
    View in PostgreSQL Archives →
    • Jump to comment-1
      Siraj G<tosiraj.g@gmail.com>
      Apr 29, 2026, 9:09 AM UTC
      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

      View in PostgreSQL Archives →
    • Jump to comment-1
      Adrian Klaver<adrian.klaver@aklaver.com>
      Apr 29, 2026, 5:41 PM UTC
      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
      View in PostgreSQL Archives →