postgresql:pg_restore: [archiver] input file does not appear to be a valid archive
来源:互联网 发布:mg 知乎 编辑:程序博客网 时间:2024/05/21 11:04
使用ps_restore恢复备份数据库出错:pg_restore: [archiver] input file does not appear to be a valid archive
使用
pg_dump -Fp -t mytable > mytable_back
或
g_dump -t mytable > mytable_back
备份出来的为脚本(纯文本)文件,不能直接使用pg_restore进行恢复。
需要使用命令psql \i
user>psql -U username -d mydb
username=# \i mytable_back
pg_dump和pg_restore的时候使用 格式为 custom(-F c )或tar格式(-F t)即可进行恢复
- postgresql:pg_restore: [archiver] input file does not appear to be a valid archive
- git does not appear to be a git repository
- Could not scan for classes inside "database/seeds" which does not appear to be a file nor a folde
- GitHub# fatal: 'origin' does not appear to be a git repository
- 使用git,clone时报does not appear to be a git repository
- The security key for this program currently stored on your system does not appear to be valid for th
- archive for required library could not be read or is not a valid ZIP file
- git push origin master fatal: 'origin' does not appear to be a git repository fatal: Could not read
- 使用Gem install安装starling出错 ERROR: http://gems.rubyforge.org/ does not appear to be a rep
- repo sync出现“fatal: '../platform/abi/cpp.git' does not appear to be a git repository”的解决方案
- repo sync出现“fatal: '../platform/abi/cpp.git' does not appear to be a git repository”的解决方案
- repo sync出现“fatal: '../platform/abi/cpp.git' does not appear to be a git repository”的解决方案
- repo sync出现“fatal: '../platform/abi/cpp.git' does not appear to be a git repository”的解决方案
- Project property "XFire services.xml path" does not refer to a valid file解决办法
- Project property "XFire services.xml path" does not refer to a valid file问题解决
- linux下安装PHP的CI框架,出现Your view folder path does not appear to be set correctly. Please open the following file and correct this: i
- Archive for required library: "xxxx" in project '*' cannot be read or is not a valid ZIP file
- maven 构建项目出现(Archive for required library: cannot be read or is not a valid ZIP file)
- 关于新浪微博与腾讯微博从Oauth1.0升级到Oauth2.0的过程
- QString
- 学习OpenCV——HOG+SVM
- 分类型式的log4j用法
- httpd: Could not reliably determine the server's
- postgresql:pg_restore: [archiver] input file does not appear to be a valid archive
- 并发数据结构:谈谈volatile变量
- Oracle SQL性能优化
- 谷歌 Chrome Dev Tools 浅析 – 成为更高效的 Developer
- OpenCV码源笔记——(letter_recog.cpp)随机Forest部分
- WPF 设置TextBox为空时,背景为文字提示。
- 练习笔记11
- 练习笔记10
- 程序员必知8大排序3大查找(一)