Re: Proposal: pg_createsubscriber use without superuser privileges - Mailing list pgsql-hackers

From Zane Duffield
Subject Re: Proposal: pg_createsubscriber use without superuser privileges
Date
Msg-id CACMiCkVSzvx4mg79ReyeKzY1Pb-yj1F6VdmJdguetETfLjXpvw@mail.gmail.com
Whole thread Raw
In response to RE: Proposal: pg_createsubscriber use without superuser privileges  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
List pgsql-hackers
Thanks, Hayato-san.
I should have checked the devel documentation before mailing in, because that new feature would satisfy my needs.

On Wed, Feb 4, 2026 at 2:33 PM Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com> wrote:
Dear Zane,

Thanks for the proposal! Your voice is always welcomed.

> I wonder whether pg_createsubscriber could be extended to use an existing
> publication, after confirming that it is equivalent to the one it would have
> created itself.

I did not fully confirm your point, but I feel the commit [1] allowed us to
re-use the existing publications. Can you try with the development version of PG
and check whether it satisfies your needs?

[1]: https://github.com/postgres/postgres/commit/85ddcc2f4cdef490276d151c80459e287bceb782

Best regards,
Hayato Kuroda
FUJITSU LIMITED

pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Proposal: pg_createsubscriber use without superuser privileges
Next
From: wenhui qiu
Date:
Subject: Re: Convert NOT IN sublinks to anti-joins when safe