RE: Proposal: pg_createsubscriber use without superuser privileges

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: 'Zane Duffield' <duffieldzane(at)gmail(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:33:01
Message-ID: OS9PR01MB121493F6A8C629193DEB729D2F598A@OS9PR01MB12149.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zane Duffield 2026-02-04 03:40:04 Re: Proposal: pg_createsubscriber use without superuser privileges
Previous Message Ashutosh Bapat 2026-02-04 03:06:35 Re: Remove freelist reference in buf_init.c