Hi all, I am attempting to restore a backup to an Azure PostgreSQL azure database, however getting the following error. "does not contain pg_restore" I can see in the \win\ folder there is no folder for version 16, only 10. Does anyone know how I can add this or force it to use an older version?

Azure Data Studio, postgres restore 16 error

Garion Swann 0

Hi all,

I am attempting to restore a backup to an Azure PostgreSQL azure database, however getting the following error. User's image

"does not contain pg_restore"

I can see in the \win\ folder there is no folder for version 16, only 10.

Does anyone know how I can add this or force it to use an older version?

Mahesh Kurva 1,470 Reputation points Microsoft Vendor

2024-09-18T07:19:49.7733333+00:00
Hi @Garion Swann,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Regarding the question:

You are trying to restore a backup to an Azure PostgreSQL database using Azure Data Studio and encountering an error that says, "does not contain pg_restore".

To resolve this issue, you can try the following steps:

Download the corresponding version of PostgreSQL from the official website and install it on your system.

Follow the installation instructions for the version you downloaded.

Find the Installation Path:

Add to PATH:

Right-click on This PC or Computer and select Properties.

Click on Advanced system settings.

In the System Properties window, click the Environment Variables button.

In the Environment Variables window, find the Path variable in the System variables section, select it, and click Edit.

Click New and add the path to the PostgreSQL bin folder.

Click OK to close all dialog boxes.

Open a new Command Prompt window

Run

psql --version

Once psql is recognized, you can proceed with using pg_restore.

I hope this information helps. Please do let us know if you have any further queries.
Mahesh Kurva 1,470 Reputation points Microsoft Vendor

2024-09-19T11:24:52.9433333+00:00

Hi @Garion Swann,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 1,470 Reputation points Microsoft Vendor

2024-09-20T10:15:31.9266667+00:00

Hi @Garion Swann,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Azure Data Studio, postgres restore 16 error

Your answer