无效的转储格式 pgbackups:即使有Dropbox的下载链接也能恢复[英] Invalid dump format pgbackups:restore even with Dropbox download link

本文是小编为大家收集整理的关于无效的转储格式 pgbackups:即使有Dropbox的下载链接也能恢复的处理方法,想解了无效的转储格式 pgbackups:即使有Dropbox的下载链接也能恢复的问题怎么解决?无效的转储格式 pgbackups:即使有Dropbox的下载链接也能恢复问题的解决办法?那么可以参考本文帮助大家快速定位并解决问题。

问题描述

我正在尝试将数据从我的本地PostgreSQL转储文件传输到HEROKU数据库. 我一直在尝试使用PGBACKUPS:使用我在So So中发现的提示还原,但是下面的错误是一个砖墙:"无效的转储格式HTML文档文本".我认为问题肯定在于Dropbox.

单击"共享"链接后,我尝试从此Dropbox屏幕(下载按钮上的链接)复制URL.但是,下面显示的"无效转储格式HTML文档文本"错误是持续存在的.我尝试了不同的URL排列(HTTPS www,https dl,http www ...他们都给我相同的错误)

在此处输入图像说明

$ heroku pgbackups:恢复heroku_postgresql_blue_url' s/80vy8mm6enwsdfo/mydb.dump '

heroku_postgresql_blue_url(database_url)<--- restore --- mydb.dump

!警告:破坏性行动!此命令将影响 应用:Terrysquotes!要继续,键入" appName"或重新运行此 命令与-confirm AppName

$ appName

检索...完成

!发生错误,您的还原没有完成.呢请 运行heroku logs --ps pgbackups以获取详细信息.

$ heroku logs -ps pgbackups

2014-06-22T16:44:11+00:00应用程序[PGBACKUPS]:PSQL:bin//pg-latest/psql 2014-06-22T16:44:11+00:00应用程序[PGBACKUPS]: --------+------+------+------- 2014-06-22T16:44:11+00:00 APP [PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22T16:44:12+00:00 App [pgbackups]:无效 转储格式:/tmp/4xhvprpkdu/mydb.dump:html文档文本 2014-06-22T16:44:12+00:00应用程序[PGBACKUPS]:download_progress:完成 2014-06-22T16:44:11+00:00应用程序[PGBACKUPS]:开始:Sun Jun 22 16:44:11 UTC 2014 2014-06-22T16:44:11+00:00 APP [PGBACKUPS]: Download_progress:Start 2014-06-22T16:44:12+00:00 App [pgbackups]: Download_progress:486.0Bytes 2014-06-22t16:44:11+00:00 应用程序[PGBACKUPS]:位置: 0D306785-C6E9-42A6-AB66-3FB55F7F7F7F6E:/TMP/4XHVPRPKDU 2014-06-22T16:44:11+00:00应用程序[PGBACKUPS]:架构|名称|类型|信息 2014-06-22T16:45:39+00:00 APP [PGBACKUPS]:PSQL:BIN//PG-LATEST/PSQL 2014-06-22T16:45:39+00:00应用程序[PGBACKUPS]:下载_Progress:496b 2014-06-22T16:45:39+00:00 App [pgbackups] :( 0行) 2014-06-22T16:45:39+00:00应用程序[PGBACKUPS]:架构|名称|类型|信息 2014-06-22T16:45:38+00:00应用程序[PGBACKUPS]:位置: 41095E94-2A25-42C5-A778-0F37D6D0FBD9:/TMP/BI1ZFET590 2014-06-22T16:45:39+00:00应用程序[PGBACKUPS]:download_progress:开始 2014-06-22T16:45:38+00:00应用程序[PGBACKUPS]:开始:Sun Jun 22 16:45:38 UTC 2014 2014-06-22T16:45:39+00:00 APP [PGBACKUPS]: 2014-06-22T16:45:39+00:00应用程序[PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22t16:45:39+00:00:00 App [pgbackups]:--------+-------+-------+--------------------------------------------------- 2014-06-22T16:45:39+00:00应用程序[PGBACKUPS]:PV:BIN//PV-LATEST 2014-06-22T16:45:40+00:00应用程序[PGBACKUPS]:download_progress: 496.0Bytes 2014-06-22T16:45:39+00:00 App [pgbackups]:2014-06-06-22T16:45:40+00:00 APP [PGBACKUPS]:INVALID FUMP格式: /TMP/BI1ZFET590/MYDB.DUMP:HTML文档文本 2014-06-22T16:45:40+00:00应用程序[PGBACKUPS]:download_progress:完成 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:2014-06-22T16:47:32+00:00:00 App [PGBACKUPS]:PSQL:BIN//PG-LATEST/PSQL 2014-06-22T16:47:32+00:00:00 应用程序[pgbackups]:下载_progress:226.0bytes 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22t16:47:32+00:00:00 App [PGBACKUPS]:下载_Progress:完成2014-06-22T16:47:32+00:00 App [PGBACKUPS]:PV:BIN//PV-LATEST 2014-06-22T16:47:32+00:00:00 应用程序[PGBACKUPS]:架构|名称|类型|信息2014-06-22T16:47:32+00:00 应用程序[PGBACKUPS]:无效的转储格式:/TMP/WAHMUTNOLF/MYDB.DUMP:HTML 文档文本2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:开始:Sun 6月22日16:47:32 UTC 2014 2014-06-22T16:47:32+00:00 APP [PGBACKUPS]: 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:下载_progress:226b 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:download_progress:开始 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]:位置: 3A91CCFA-A2C0-4277-B84B-D2BE43E4A834:/TMP/WAHMUTNOLF 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS] :( 0行) 2014-06-22T16:47:32+00:00应用程序[PGBACKUPS]: --------+------+------+------- 2014-06-22T16:50:48+00:00 APP [PGBACKUPS]:PSQL:bin//PG-LATEST/PSQL 2014-06-22T16:50:49+00:00 App [PGBACKUPS]:下载_Progress:完成2014-06-22T16:50:48+00:00 应用程序[PGBACKUPS]:位置: FF26E7C9-51B1-49A9-8EAC-96380E518059:/TMP/E940S4ZIPP 2014-06-22T16:50:48+00:00应用程序[PGBACKUPS]: --------+------+------+------- 2014-06-22T16:50:48+00:00 APP [PGBACKUPS]:DOWARTIS__PROGRESS:486B 2014-06-22T16:50:48+00:00 应用程序[PGBACKUPS]:架构|名称|类型|信息2014-06-22T16:50:48+00:00 App [PGBACKUPS]:下载_Progress:Start 2014-06-22T16:50:48+00:00 应用程序[PGBACKUPS]:开始:Sun Jun 22 16:50:48 UTC 2014 2014-06-22T16:50:49+00:00应用程序[PGBACKUPS]:download_progress: 486.0bytes 2014-06-22T16:50:48+00:00 app[pgbackups]: pg_restore: env LD_LIBRARY_PATH=bin//9.3 bin//9.3/pg_restore 2014-06-22T16:50:48+00:00 应用程序[PGBACKUPS]:2014-06-22T16:50:48+00:00 APP [PGBACKUPS]: 2014-06-22T16:50:48+00:00应用程序[PGBACKUPS]:PV:BIN//PV-LATEST 2014-06-22T16:50:48+00:00应用程序[PGBACKUPS] :( 0行) 2014-06-22T16:50:49+00:00应用程序[PGBACKUPS]:无效的转储格式: /TMP/E940S4ZIPP/MYDB.DUMP:HTML文档文本 2014-06-22T16:53:27+00:00应用程序[PGBACKUPS]: --------+------+------+------- 2014-06-22T16:53:27+00:00 APP [pgbackups]:download_progress:386b 2014-06-22T16:53:27+00:00 应用程序[PGBACKUPS]:开始:Sun Jun 22 16:53:27 UTC 2014 2014-06-22T16:53:27+00:00应用程序[PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22T16:53:27+00:00:00 应用程序[PGBACKUPS]:2014-06-22T16:53:27+00:00 APP [PGBACKUPS]: Download_progress:386.0Bytes 2014-06-22t16:53:27+00:00 应用程序[PGBACKUPS]:位置: 44AAA82B-B329-4EA8-B869-AF74A2291D2D:/TMP/AR3NXH75CR 2014-06-22T16:53:27+00:00应用程序[PGBACKUPS]:架构|名称|类型|信息 2014-06-22T16:53:27+00:00应用程序[PGBACKUPS]:download_progress:开始 2014-06-22T16:53:28+00:00应用程序[PGBACKUPS]:无效的转储格式: /TMP/AR3NXH75CR/MYDB.DUMP:HTML文档文本 2014-06-22T16:53:27+00:00 APP [PGBACKUPS]:PSQL:BIN//PG-LATEST/PSQL 2014-06-22T16:53:27+00:00应用程序[PGBACKUPS]:2014-06-22T16:53:27+00:00:00:00 应用程序[PGBACKUPS]:PV:BIN//PV-LATEST 2014-06-22T16:53:27+00:00:00 应用程序[PGBACKUPS] :( 0行)2014-06-22T16:53:27+00:00 App [PGBACKUPS]: Download_progress:完成2014-06-22T17:01:39+00:00应用程序[PGBACKUPS]: Download_progress:开始2014-06-22T17:01:38+00:00 App [PGBACKUPS]:PV: BIN//PV-LATEST 2014-06-22T17:01:39+00:00 APP [PGBACKUPS]: Download_progress:486B 2014-06-22T17:01:39+00:00应用程序[PGBACKUPS]: --------+------+-------+------- 2014-06-22T17:01:38+00:00 App [pgbackups]:开始:Sun 6月22日17:01:38 UTC 2014 2014-06-22T17:01:39+00:00应用程序[PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22t17:01:39+00:00:00 应用程序[PGBACKUPS]:2014-06-22T17:01:38+00:00 APP [PGBACKUPS]:PSQL: bin//pg-latest/psql 2014-06-22T17:01:39+00:00 App [pgbackups]:架构 |名称|类型|信息2014-06-22T17:01:3 9+00:00应用程序[PGBACKUPS]: Download_progress:486.0Bytes 2014-06-22t17:01:39+00:00 App [PGBACKUPS]:下载_Progress:完成2014-06-22T17:01:38+00:00 应用程序[PGBACKUPS]:位置: AA3C5322-1899-4811-B74E-FFF91218FC6C:/TMP/WQC9ZISVIA 2014-06-22T17:01:39+00:00应用程序[PGBACKUPS]:2014-06-22T17:01:39+00:00:00 应用程序[PGBACKUPS]:(0行)2014-06-22T17:01:39+00:00 APP [PGBACKUPS]: 无效转储格式:/tmp/wqc9zisvia/mydb.dump:html文档文本 2014-06-22T17:01:56+00:00 APP [PGBACKUPS]:PSQL:BIN//PG-LATEST/PSQL 2014-06-22T17:01:56+00:00应用程序[PGBACKUPS]:download_progress:开始 2014-06-22T17:01:56+00:00 APP [PGBACKUPS]:2014-06-22T17:01:56+00:00:00 应用程序[PGBACKUPS]:位置: D5F20719-B1B1-4A8F-9E92-BB45D19A5479:/TMP/S2EB3HRQGP 2014-06-22T17:01:56+00:00应用程序[PGBACKUPS]:PG_RESTORE:ENV ld_library_path = bin//9.3 bin//9.3/pg_restore 2014-06-22t17:01:56+00:00:00 应用程序[PGBACKUPS]:(0行)2014-06-22T17:01:56+00:00 APP [PGBACKUPS]: 开始:6月22日17:01:56 UTC 2014 2014-06-22T17:01:56+00:00 App [PGBACKUPS]:PV:BIN//PV-LATEST 2014-06-22T17:01:56+00:00:00 应用程序[PGBACKUPS]:架构|名称|类型|信息2014-06-22T17:01:56+00:00 App [pgbackups]:--------+-------+-------+--------------------------------------------------- 2014-06-22T17:01:56+00:00应用程序[PGBACKUPS]:下载_progress:386b 2014-06-22T17:01:56+00:00 APP [PGBACKUPS]:2014-06-22T17:01:56+00:00:00 App [pgbackups]:download_progress:386.0bytes 2014-06-22T17:01:56+00:00应用程序[PGBACKUPS]:下载_progress:完成 2014-06-22T17:01:56+00:00应用程序[PGBACKUPS]:无效的转储格式: /TMP/S2EB3HRQGP/MYDB.DUMP:HTML文档文本

推荐答案

我想您想要/80vy8mm6enwsdfo/mydb.dump .请参阅 https://www.dropbox.com/help/201/201/en ,有关详细信息.

本文地址:https://www.itbaoku.cn/post/1764212.html