[code="shell"]
# 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
[/code]
[size=x-large][size=small][color=red]备份出来的为脚本(纯文本)文件,不能直接使用pg_restore进行恢复。[/color][/size][/size]
[code="shell"]
# 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
[/code]
# 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
[/code]
[size=x-large][size=small][color=red]备份出来的为脚本(纯文本)文件,不能直接使用pg_restore进行恢复。[/color][/size][/size]
[code="shell"]
# 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
[/code]