【魄爺】 发表于 2016-11-21 07:40:20

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

# 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: input file does not appear to be a valid archive


备份出来的为脚本(纯文本)文件,不能直接使用pg_restore进行恢复。


# 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
页: [1]
查看完整版本: postgresql:pg_restore: [archiver] input file does not appear to be a valid archi