从本地推送postgres数据到heroku的postgres数据库报错
source link: https://www.oschina.net/question/4493522_2323524
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
从本地推送postgres数据到heroku的postgres数据库报错
本地环境：win11/postgreSQL 13
通过CMD使用以下命令推送：
heroku pg:push cisdatabase postgresql-polished-14609 --app chem2reg卡在以下错误上:
#: pg_backup_custom.c:471 #, c-format msgid "unrecognized data block type (%d) while searching archive\n" msgstr "搜索归档是碰到不识别的数据块类型 (%d)\n"
本地dump和restore都没有问题，push到远端就卡在这里，数据里只有一个表，数据量才52行。
遍觅国内外各大社区不得其解，抓耳挠腮，心痒难以，恳切求教postgreSQL专家指点一二！
在下初入门postgreSQL，待发现这片人烟稀少想回身已不及，话说postgreSQL那么棒，为啥无论国内外的相关社区都这么寂寥？
Recommend
-
16
Why You Should Migrate your Heroku Postgres Database to AWS RDS Updated Oct 6, 2020 4 comments 9 minute read ...
-
14
How to Backup Heroku Postgres Database to an Encrypted AWS S3 Bucket Updated May 12, 2020 16 comments 8 minute read
-
9
Today we’re adding another Magic Dashboard! Here’s what we’ve added, and which metrics are useful to track. Heroku (host) metrics A while ago we introduced
-
6
Connection Pooling for Heroku Postgres Is Now Generally Available Posted by Greg Nokes
-
6
Announcing Heroku Postgres Enhancements: 40x Faster Backups Posted by Greg Nokes an...
-
5
Announcing Larger Heroku Postgres Plans: More Power, More Storage Posted by Greg Nokes
-
8
Borealis Isolated Postgres Borealis Isolated Postgres Beta A PostgreSQL database add-on...
-
5
This article was published as a part of the Data Science Blogathon. Introduction Recently I was doing an analysis, and in this an...
-
11
Introducing New Heroku Postgres Plans Posted by Jonathan K. BrownPr...
-
4
Sync Salesforce and Postgres: alternative to Heroku ConnectSort by: Hey Product Hunt! Forrest from Circular Sync here We built Circular Sync because because of the pain points we experienced: 1. Rarely having th...
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK