Share via

Azure Backup Vault for PostgreSQL replica failing

Linus Hamlin 1 Reputation point
2021-10-15T11:35:11.027+00:00

Hi,

I can't get Azure Backup Vault working for PostgreSQL replica.

The error I get is: 

pg_dump: [archiver (db)] query failed: ERROR:  cannot use serializable mode in a hot standby HINT:  You can use REPEATABLE READ instead. pg_dump: [archiver (db)] query was: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, READ ONLY, DEFERRABLE

I know the postgres backup feature is in preview, but just want to check if anyone has experienced similar problems and found a workaround?
Doing a backup on the master server works fine.

Best regards,

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,490 questions
Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator
    2021-11-04T22:42:11.64+00:00

    Hi @Linus Hamlin Thank you for being patient while working on this issue.

    The current config of Azure backup doesn’t work with replica, as a workaround, you can configure it with the primary server

    Please let us know if that help

    Regards,
    Oury

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.