Backup stratergy for Azure PostgreSQL

F Ahmed 36 Reputation points
2020-06-04T22:13:42.417+00:00

I understand by default Azure keeps backups for PostgreSQL for upto 35 days. How can i increase that? Do i need to have a custom backup strategy if i want to maintain backup for more upto 7 years? I m new to PostgreSQL so details are appreciated.

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Leon Laude 85,596 Reputation points
    2020-06-04T22:35:11.077+00:00

    Hi,

    The automatic backups, which are part of the Azure PostgreSQL services cannot be altered as far as I know.
    This means that the 35 days is the max retention available as of today.

    If you want a longer retention time, I suggest you post feedback about this over at the Azure Database for PostgreSQL uservoice page over here:
    https://feedback.azure.com/forums/597976-azure-database-for-postgresql

    Best regards,
    Leon

    1 person found this answer helpful.
    0 comments No comments

  2. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2020-06-05T22:09:19.36+00:00

    Hi @FAhmed-4761

    Yes the current maximum retention period is for 35 days as described here.

    This also describes the method for the pg_dump. Although not elegant but if 7 years retention is a necessity, you can work out a strategy to keep backups using pg_dump in storage.

    Hope this helps. Thanks

    Navtej S