Azure Database for PostgreSQL - Flexible Server: Setting Session Replication Role in JDBC Options

Question

Is it possible to set the session replication role in JDBC options for Azure Database for PostgreSQL - Flexible Server (Postgres v13)?

While I was able to execute SET session_replication_role = 'replica' directly in the database, I encountered an error when trying to configure it in the JDBC options: "Permission denied to set parameter 'session_replication_role'."

Here’s the JDBC connection string I used:

jdbc:postgresql://xxxx:5432/postgres?options=-c%20session_replication_role=replica

Answer 1

Hi @lye,

Thanks for the question and using MS Q&A platform.

The error "Permission denied to set parameter 'session_replication_role'" happens because PostgreSQL doesn't allow certain settings to be changed by regular users. These settings, like session_replication_role, can only be modified by superusers.

In Azure Database for PostgreSQL - Flexible Server, non-superuser accounts cannot change this parameter directly, even when using the JDBC connection string. This is done for security and performance reasons.

Please go through this documentation that might help you: session_replication_role

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.