Long Term Retention for Azure Database for PostgreSQL RRS feed

  • Question

  • Hi Guys,

    What is LTR plan for azure postgresql DB. We have 10 years of LTR for Azure SQL Database. I dont see a similar option for azure postgresql DB.

    I have 1 option in my mind which i need to test

    pg_dump -Fc -v --host=<host> --username=<name> --dbname=<database name> > <database>.dump

    Prepare a shell script or batch script and schedule it in linux or windows server.

    Is there any other approach that is being practiced, please advise.

    Thursday, August 29, 2019 7:29 PM

All replies