How to automate tasks in Azure Database for PostgreSQL server (Crontab seems not to work)

Question

Hello all,

I need to automate the following process in my Azure Database for PostgreSQL server, but it seems my Crontab isn't working (like I don't have permission). Does anyone already face something like this? What would be a good workaround?

I have created scripts that would be run by cron. The scripts/tasks that I need to get done Daily are:

(All this I have scripts that are working for, I just included to help with clarification of the situation)

1. Drop the current DB
2. Download the new DB dump
3. Extract the DB dump file
4. Build the DB

Any way to automatize tasks in the Azure Database for PostgreSQL server ?

thanks!!

Answer 1

Hi @Pedro

Thanks for the question. I believe your scenario is possible using Azure Pipelines task for Azure Database for PostgreSQL Flexible Server. You can automatically deploy your database updates to Azure Database for PostgreSQL Flexible Server after every successful build with Azure Pipelines.

Alternatively, you can use Azure automation or Azure functions to automate tasks.

Hope that helps. Please let us know if you have further questions.

Thanks,
Grace

------------------------------------------------------------------------------------------------------------------------------

--If the reply is helpful, please Upvote and Accept as answer--