当前位置:数据库 > SQLServer >>

postgresql:pg_restore: [archiver] input file does not appear to be a valid archi

postgresql:pg_restore: [archiver] input file does not appear to be a valid archi
 
Shell代码  
[root@ShadowFiend Gogo_yueyue]# pg_restore --host localhost --port 5432 --username postgres --data-only  --dbname dytanmicRisk  --table project_Latitude --schema public  --verbose "/home/Gogo_yueyue/下载/dyranmicRisk.sql"   
pg_restore: [archiver] input file does not appear to be a valid archive  
  www.zzzyk.com  
[size=small]备份出来的为脚本(纯文本)文件,不能直接使用pg_restore进行恢复。[/size] 
 
Shell代码  
[root@ShadowFiend Gogo_yueyue]# psql -U postgres -d dyranmicRisk  
Password for user postgres:   
psql.bin (9.1.1)  
Type "help" for help.  
  
dyranmicRisk=# \i /home/Gogo_yueyue/下载/dyranmicRisk.sql   
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,