如何从Heroku pg：backups副本恢复数据库

mcdcgff0 于 2023-01-21 发布在其他

关注(0)|答案(1)|浏览(94)

如果运行heroku pg:backups --app MY_APP，则会看到：

=== Backups
No backups. Capture one with heroku pg:backups:capture

=== Restores
No restores found. Use heroku pg:backups:restore to restore a backup

=== Copies
ID    Started at                 Status                               Size      From       To
────  ─────────────────────────  ───────────────────────────────────  ────────  ─────────  ───────────
c001  2021-02-23 15:47:54 +0000  Completed 2021-02-23 15:48:27 +0000  509.16KB  From Name  Target Name

如果运行heroku pg:backups:info c001 --app MY_APP，则会看到：

=== Backup c001
Database:         From Name
Started at:       2021-02-23 15:47:54 +0000
Finished at:      2021-02-23 15:48:27 +0000
Status:           Completed
Type:             Manual
Original DB Size: 11.53MB
Backup Size:      509.16KB (96% compression)

=== Backup Logs

但是，当我尝试使用heroku pg:backups:restore c001 --app MY_APP恢复此备份时，它告诉我Backup c001 not found for MY_APP。
有什么方法可以恢复这个副本吗？对于上下文，我的数据库是在免费计划中，并被Heroku删除，所以据我所知，这是我的最后一次备份。
谢谢大家！

heroku

来源：https://stackoverflow.com/questions/75166128/how-to-restore-a-db-from-a-heroku-pgbackups-copy

1条答案

按热度按时间

vvppvyoh1#

备份从b00 * 开始，列在顶部。我不确定什么是"副本"，在他们的文档中没有找到任何东西。

❯ heroku pg:backups -r prod
=== Backups
ID    Created at                 Status                               Size      Database
────  ─────────────────────────  ───────────────────────────────────  ────────  ────────
b008  2021-05-04 06:57:18 +0000  Completed 2021-05-04 06:57:20 +0000  664.15KB  DATABASE
b007  2021-05-04 05:33:50 +0000  Completed 2021-05-04 05:33:52 +0000  663.53KB  DATABASE

=== Restores
No restores found. Use heroku pg:backups:restore to restore a backup

=== Copies
ID    Started at                 Status                               Size      From       To
────  ─────────────────────────  ───────────────────────────────────  ────────  ─────────  ───────────
c009  2022-06-23 03:28:14 +0000  Completed 2022-06-23 03:28:46 +0000  232.80KB  From Name  Target Name
c002  2020-05-27 15:29:37 +0000  Completed 2020-05-27 15:29:40 +0000  112.59KB  From Name  Target Name
c001  2020-05-26 19:43:26 +0000  Completed 2020-05-26 19:43:37 +0000  112.97KB  From Name  Target Name

❯ heroku pg:backups:restore c009 --app <app>
 ▸    Backup c009 not found for ⬢ <app>

❯ heroku pg:backups:restore b008 --app <app>
 ▸    WARNING: Destructive Action
 ▸    This command will affect the app <app>
 ▸    To proceed, type <app> or re-run this command with --confirm
 ▸    <app>
...

赞(0）回复(0）举报 2023-01-21

我来回答

如何从Heroku pg：backups副本恢复数据库

1条答案

相关问题

热门标签

最新问答