Re: Proposal: pg_createsubscriber use without superuser privileges

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
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Hayato Kuroda (Fujitsu) 2026-02-04 03:33:01 RE: Proposal: pg_createsubscriber use without superuser privileges