python - 从 Heroku 中提取数据库但无法处理数据

Question

我使用 pg:pull 将数据库拉到本地数据库。在进入处理数据步骤之前，一切都按预期工作。

这是我收到的错误，它出现在数据库的第一个条目上。

pg_restore: processing data for table "a1pavingco.account_emailaddress"
pg_restore: error: unrecognized data block type (0) while searching archive
events.js:287
  throw er; // Unhandled 'error' event
  ^

Error: write EPIPE
   at afterWriteDispatched (internal/stream_base_commons.js:154:25)
   at writeGeneric (internal/stream_base_commons.js:145:3)
   at Socket._writeGeneric (net.js:784:11)
   at Socket._write (net.js:796:8)
   at doWrite (_stream_writable.js:442:12)
   at writeOrBuffer (_stream_writable.js:426:5)
   at Socket.Writable.write (_stream_writable.js:317:11)
   at Socket.ondata (_stream_readable.js:695:22)
   at Socket.emit (events.js:310:20)
   at Socket.Readable.read (_stream_readable.js:493:10)
Emitted 'error' event on Socket instance at:
   at errorOrDestroy (internal/streams/destroy.js:108:12)
   at Socket.onerror (_stream_readable.js:729:7)
   at Socket.emit (events.js:310:20)
   at errorOrDestroy (internal/streams/destroy.js:108:12)
   at onwriteError (_stream_writable.js:457:5)
   at onwrite (_stream_writable.js:484:5)
   at internal/streams/destroy.js:50:7
   at Socket._destroy (net.js:677:5)
   at Socket.destroy (internal/streams/destroy.js:38:8)
   at afterWriteDispatched (internal/stream_base_commons.js:154:17) {
errno: 'EPIPE',
code: 'EPIPE',
syscall: 'write'
}

我不知道该怎么处理这个错误或如何修复它。我可以通过 PGAdmin 查看数据库，但是列中没有条目。我已经用什么都不返回的查询进行了测试。任何有关如何解决此问题的建议将不胜感激！

标签： pythondjangodatabasepostgresqlheroku