| From: | Zane Duffield <duffieldzane(at)gmail(dot)com> |
|---|---|
| To: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal: pg_createsubscriber use without superuser privileges |
| Date: | 2026-02-04 03:40:04 |
| Message-ID: | CACMiCkVSzvx4mg79ReyeKzY1Pb-yj1F6VdmJdguetETfLjXpvw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)hayato(at)fujitsu(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | Hayato Kuroda (Fujitsu) | 2026-02-04 03:33:01 | RE: Proposal: pg_createsubscriber use without superuser privileges |