create a job in gov cloud to restart PostgreSQL service once every 2 weeks in the gov cloud.

Question

Hi. I need to create a job in gov cloud to restart this service once every 2 weeks at a specific day and time. How can I do that? The Automation feature is not available in the gov cloud.

Answer 1

To create a job to restart the PostgreSQL service in Azure Government Cloud every two weeks, you can use automation tasks. However, since you mentioned that the Automation feature is not available in the Gov Cloud, you may need to consider using Azure Logic Apps to achieve this.

Here’s a general approach:

1. Create a Logic App: In the Azure portal, create a new Logic App.
2. Define the Trigger: Set the trigger to a recurrence schedule that runs every two weeks. You can specify the exact day and time in the recurrence settings.
3. Add an Action: Use the action to restart your PostgreSQL server. You can use the Azure Management API or a built-in connector to perform the restart operation.
4. Save and Test: Save your Logic App and test it to ensure it works as expected.

This way, you can automate the restart of your PostgreSQL service according to your specified schedule, even in the absence of the Automation feature in the Gov Cloud.

---

References:

• Quickstart: Manage Azure Database for PostgreSQL using automation tasks