pg_dump和pg_restore

问题：
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 4965; 0 138871 TABLE DATA ir_act_report_xml insigni
pg_restore: [archiver (db)] could not execute query: ERROR:  invalid input syntax for integer: "purchase.order"
LINE 1: ...st for Quotation', 'ir.actions.report.xml', NULL, 'purchase....


解决办法：

pg_dump database_name -c -Ft -f file_name.tar 

pg_restore -d database_name -c file_name.ta

参考地址

https://stackoverflow.com/questions/9836627/pg-restore-toc-error