Must be superuser to create subscriptions - Any way I can avoid using superuser

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Must be superuser to create subscriptions - Any way I can avoid using superuser
Date: 2021-07-01 08:43:50
Message-ID: DB9PR07MB7180F00FF31BAE0300388E19CB009@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to avoid using superuser to create subscriptions (logical replication). If I do not use superuser, I get the following error message "must be superuser to create subscriptions". Is there a way to void using superuser to create a subscription? What is pg_subscription_users that I read being discussed?

Thanks!
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Browse pgsql-general by date

  From Date Subject
Next Message W.P. 2021-07-01 08:56:05 Damaged (during upgrade?) table, how to repair?
Previous Message W.P. 2021-07-01 08:12:23 Damaged (during upgrade?) table, how to repair?