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

Question

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

Kenneth Sewell 0

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?

Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-28T06:48:20.6833333+00:00

Hi @Kenneth Sewell,

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.
Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-29T17:18:45.79+00:00

Hi @Kenneth Sewell,

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.
Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-30T17:58:11.8133333+00:00

Hi @Kenneth Sewell,

Just checking in to see if the below answer helped. 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.

2 answers

Your answer

Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-28T06:48:20.6833333+00:00

Hi @Kenneth Sewell,

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.
Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-29T17:18:45.79+00:00

Hi @Kenneth Sewell,

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.
Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-30T17:58:11.8133333+00:00

Hi @Kenneth Sewell,

Just checking in to see if the below answer helped. 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.

Answer 1

Sai Raghunadh M 4,575 Microsoft External Staff Moderator

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.

0 comments

Answer 2

Kenneth Sewell 0

Thanks for the link. That answered my questions

Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-10-29T17:55:33.51+00:00

Hi @Kenneth Sewell,

Glad to know it helped. Continue to use MS Q&A platform for any questions related to Azure!

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.
Sai Raghunadh M 4,575 Reputation points Microsoft External Staff Moderator

2024-11-01T09:28:54.09+00:00

Hi @Kenneth Sewell,

Following up to see if the above answer helped. 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.

Share via

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

2 answers

Your answer