Hi, Our organisation is planning to migrate to azure Postgres from on-premise. Currently, we have a JAVA program that modifies the config parameters of Postgres. I understand that azure provides a CLI tool to modify or automate the modification of DB parameters. However are there any APIs which we can call from the JAVA program to modify the parameters? Thanks in advance!

Hi @Sajith Shetty , welcome to Microsoft Q&A forum. As I understand from your query, you want to change the config parameters using any JAVA API for Azure PostgreSQL. We can config the parameters through the Azure Portal, Azure CLI and Rest API. In your case you can call the rest API through the JAVA code and update the config. Below is the rest API call you can use: Server Parameters - List Update Configurations Configurations - Get Please let us know if that helps or else we can discuss further.

JAVA APIs to modify azure postgres parameters

Accepted answer

Anurag Sharma 17,566 Reputation points

2022-05-16T08:50:25.193+00:00

Hi @Sajith Shetty , welcome to Microsoft Q&A forum.

As I understand from your query, you want to change the config parameters using any JAVA API for Azure PostgreSQL.

We can config the parameters through the Azure Portal, Azure CLI and Rest API.

In your case you can call the rest API through the JAVA code and update the config. Below is the rest API call you can use:

Server Parameters - List Update Configurations

Configurations - Get

Please let us know if that helps or else we can discuss further.
Please sign in to rate this answer.
Sajith Shetty 21 Reputation points

2022-05-16T09:05:34.027+00:00

Thank you for the quick response! I will make use of the links provided.

Does this work for both Flexible and hyperscale?
Also is it possible to restart the database from an API? If yes, link please.
Thanks

Anurag Sharma 17,566 Reputation points

2022-05-16T09:12:06.253+00:00

Thanks @Sajith Shetty for replying back.

There are separate REST API calls for both Single Server and Flexible Server.

Single Server REST operations

Flexible Server REST operations

Based on the server we can choose either of them.

----------

If answer is helpful please click on as it could help other members of the Microsoft Q&A community who have similar questions and are looking for solutions. Thank you for helping to improve Microsoft Q&A!

Sajith Shetty 21 Reputation points

2022-05-16T09:15:52.217+00:00

What about Hyperscale citus version?

Anurag Sharma 17,566 Reputation points

2022-05-16T09:47:50.71+00:00

As much as I am aware only Single Server and Flexible Server Support Rest API calls.

Azure Database for PostgreSQL REST API

I have also reached out to internal team to confirm on this and will keep this thread updated based on the response.

However we can update these configuration using simple sql statements as mentioned in the below article:

Server parameters

Anurag Sharma 17,566 Reputation points

2022-05-16T15:19:16.927+00:00

Hi @Sajith Shetty , thanks for your patience.

We got the confirmation from product team that for Hyperscale changing the parameters is supported through Azure Portal and not from REST API.

Please let us know if you have any further queries.

----------

If answer helped you, please mark it 'Accept Answer'
Sign in to comment

JAVA APIs to modify azure postgres parameters

0 additional answers