Skip to content

Azure Data Studio - PostgreSQL extension unable to restore DB from a backup .TXT file #507

@mandar-lad

Description

@mandar-lad

Scenario:

  1. I installed this PostgreSQL extension obtained via marketplace search on the Azure Data Studio (ADS) on my mac (Sonoma 14.6.1)
  2. On ADS, I connected to a Postgres DB named oltpdb hosted on an existing Postgres SQL server (Azure DB for PostgreSQL single server)
  3. I took its back up in the form of a .TXT file stored in a local directory on my mac.
  4. Then I connected to another Postgres DB having the same name oltpdb but hosted on a new Postgres SQL server (Azure DB for PostgreSQL - Flexible Server).
  5. Now I am trying to restore the back up .txt file to create all of the DB structures (schemas, tables etc) in oltpdb on the new server. However each time it returns me an error
    Restore: Exe folder //.azuredatastudio/extensions/microsoft.azuredatastudio-postgresql-0.6.0/out/ossdbtoolsservice/OSX_ARM64/v1.10.0/pgsqltoolsservice/pg_exes/mac does not contain pg_restore for version 16.0.4

Since the feature page mentioned Backup and Restore as supported functionalities, I was hoping for the extension to be able to do that, but required libraries are not packaged it seems. I googled for a solution but so far did not find something worth trying. How do I fix this error?

Please also find screenshots below.

Image

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions