Is it possible to restore a Postgress database to another location than LIVE?

Kenneth Sewell 0 Reputation points
2024-10-25T16:09:29.94+00:00

We are using the standard Postgres Backup and need to restore the latest backup to another location so we can compare some changes to the database after our last code changes.

Is it possible to restore to another location? Any feedback on how to do that?

Azure Database for PostgreSQL
{count} votes

2 answers

Sort by: Most helpful
  1. Sai Raghunadh M 895 Reputation points Microsoft Vendor
    2024-10-25T20:00:48.9333333+00:00

    Hi @Kenneth Sewell,

    Thanks for the question and using MS Q&A platform.

    please go through this document that might help you. https://www.postgresql.org/docs/8.1/backup.html#BACKUP-DUMP-RESTORE

    Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.
    0 comments No comments

  2. Kenneth Sewell 0 Reputation points
    2024-10-29T17:21:33.6833333+00:00

    Thanks for the link. That answered my questions


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.