Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,038 questions
Azure Data Studio, postgres restore 16 error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 50%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garion Swann
0
Reputation points
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?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva 5 Reputation points Microsoft Vendor2024-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 --versionOnce
psqlis recognized, you can proceed with usingpg_restore.I hope this information helps. Please do let us know if you have any further queries.
-
Mahesh Kurva 5 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.
Sign in to comment
Sign in to answer