我在Linux服务器上运行了pg_dumpall命令,并试图在另一台运行相同版本Postgres(8.1.21-1.el5_5.1)的Linux服务器上恢复生成的文件。
当我尝试进行恢复时,会出现以下错误:
这个转储文件中的这些行看起来像这样(这里的第一行是10753)。
当我尝试进行恢复时,会出现以下错误:
# psql --user=postgres -f pgbackup_dcs.sql postgres
[...]
psql:pgbackup_dcs.sql:10753: ERROR: relation "sl_event" does not exist
psql:pgbackup_dcs.sql:10754: invalid command \N
psql:pgbackup_dcs.sql:10755: invalid command \N
psql:pgbackup_dcs.sql:10756: invalid command \N
psql:pgbackup_dcs.sql:10757: invalid command \N
psql:pgbackup_dcs.sql:10758: invalid command \N
psql:pgbackup_dcs.sql:10759: invalid command \N
[there are a lot of other errors following this point]
这个转储文件中的这些行看起来像这样(这里的第一行是10753)。
COPY sl_event (ev_origin, ev_seqno, ev_timestamp, ev_minxid, ev_maxxid, ev_xip, ev_type, ev_data1, ev_data2, ev_data3, ev_data4, ev_data5, ev_data6, ev_data7, ev_data8) FROM stdin;
1 687653 2010-12-08 11:54:45.669861 36713740 36713741 SYNC \N \N \N \N \N \N \N \N
1 687654 2010-12-08 11:54:55.6757 36713769 36713770 SYNC \N \N \N \N \N \N \N \N
1 687655 2010-12-08 11:55:05.68132 36713796 36713797 SYNC \N \N \N \N \N \N \N \N
我在备份和恢复过程中出了什么问题?如何在新服务器上恢复数据库?