Share via

Azure Database for PostgreSQL server - how to restore only one database from instance

Vasek Polak 80 Reputation points
2023-11-14T13:08:12.5666667+00:00

Azure Database for PostgreSQL server - how to restore only one database from instance.

There are 3 databases in instance, but we want to restore(PITR) only one.

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,018 questions
Azure Database for PostgreSQL
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 29,492 Reputation points Microsoft Employee
    2023-11-14T17:06:57.5066667+00:00

    Hi @Vasek Polak Thanks for posting your question in the Microsoft Q&A forum.

    You can only do PITR on a PostgreSQL database Instance, not on an individual database. To restore a single database from an Azure Database for PostgreSQL server, you can use the pg_restore command with the --dbname option to specify the name of the database you want to restore. Alternatively, you can restore the entire PostgreSQL instance to a new server and drop the databases you don't want to restore.

    Regards

    Geetha

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.