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

Pedro 1

How to automate tasks in Azure Database for PostgreSQL server (Crontab seems not to work)
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)

Drop the current DB
Download the new DB dump
Extract the DB dump file
Build the DB

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

GeethaThatipatri-MSFT 27,977 Reputation points Microsoft Employee

2021-12-08T04:59:02.337+00:00

Hi, @Pedro Thanks for posting your question in Microsoft Q&A.
Can you try as mentioned below.

1) Drop the current DB -- dropdb mydb
2) Download the new DB dump-- download from where?
3) Extract the DB dump file -- pg_dump mydb > mydump
4) Build the DB-- psql -f mydump

and keep all the connection details in the file so in the crontab it's easy to do something like :
source ~/.pgazure&&dropdb mydb

Example of the file I'm sourcing:
vi .pgazure

export PGDATABASE=ora2pg
export PGHOST=name.postgres.database.azure.com
export PGUSER=user@hosting
export PGPASSWORD=VeryBadPractice;)

Please let me know if you need more information

Regards
Geetha
GeethaThatipatri-MSFT 27,977 Reputation points Microsoft Employee

2021-12-09T21:55:31.297+00:00

Hi, @Pedro Did you have the chance to check the above comments.? Please let us know if you are still facing the same issue?

Regards
Geetha

Share via

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