ruby-on-rails - 尝试将 Heroku 数据库下载到本地 : Connection to Database Failed

Question

我正在关注 this尝试将我的 Heroku 数据库拉到我的本地主机的文档。我已经成功运行了 heroku pg:backups:capture 和 heroku pg:backups:download 并且在我的文件结构中看到了一个 latest.dump 文件。

但是，当我尝试运行 pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump 时，我得到以下信息错误:

pg_restore: connecting to database for restore
pg_restore: [archiver (db)] connection to database "mydb" failed: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?  could not connect to server: Connection refused      
Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

谁能帮我弄清楚如何解决这个问题？

Answer 1

要在恢复期间创建mydb 数据库，您需要--create 选项。否则，该命令将查找名为 mydb 的现有数据库，根据错误消息，该数据库似乎不存在。