Issue Restoring Backup from Azure Database for PostgreSQL to VM Deployed PostgreSQL

Dhaval Kedaria 0

Hello,

I've encountered an issue while attempting to restore a backup from an Azure Database for PostgreSQL to a PostgreSQL instance deployed on a VM.

Details:

Source: Azure Database for PostgreSQL
- Version: PostgreSQL 14.11 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
- Destination: VM Deployed PostgreSQL
  - Version: PostgreSQL 14.12, compiled by Visual C++ build 1940, 64-bit

GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee

2024-07-10T15:03:16.2133333+00:00

@Dhaval Kedaria Welcome to Microsoft Q&A thanks for posting your question.

When you say issue, what is the issue you are facing can you share more information on the error, also share the region and how you are performing backup?

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-backup-restore

Regards

Geetha
Dhaval Kedaria 0 Reputation points

2024-07-15T17:20:47.0866667+00:00

Hi Geetha,while restoring the backup file

pg_restore error: unsupported version(1.15) in file header.

region: Central India
Taking backup: using PGAdmin4 on both.Azure Database for PostgreSQL flexible servers and VM deployed Postgres.
GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee

2024-07-16T18:25:08.2+00:00

@Dhaval Kedaria Thanks for your response, can you also please share version of PGAdmin where postgres installed version

Also find the similar post on SO forum https://stackoverflow.com/questions/77802646/how-to-determine-which-pg-restore-version-to-use-with-a-given-dump-file

Regards

Geetha
GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee

2024-07-19T15:36:36.2233333+00:00

@Dhaval Kedaria We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Regards

Geetha