pg_dump -v -o -U username -ci -Ft -f "D:\Desktop\filename.tar" db_name

pg_restore -c -i -U username -d db_name -v "D:\Desktop\filename.tar" -W [The above command used for dump and restore]

You must using parameter-F t. pg_restore -F t -U user -d db filename

ok i trying the same above cmd

Facing the same error before ir_attachment all the record data are restored. Ir_attachment table and after all the table record data are not stored.

Is there any way to skip only ir_attachment table only? and all other table data restore and finally restore ir_attachment Thanks

2013-06-24 07:29:56 EDT ERROR: missing data for column "store_fname" 2013-06-24 07:29:56 EDT CONTEXT: COPY ir_attachment, line 490: "601 26 2012-07-13 09:29:57.467 \N \N \N Ruth Scott_PICC Exchange_.." 2013-06-24 07:29:56 EDT STATEMENT: COPY ir_attachment (id, create_uid, create_date, write_date, write_uid, description, datas_fname, url, res_model, company_id, res_name, type, res_id, file_size, db_datas, store_fname, name, file_type, partner_id, user_id, parent_id, index_content) FROM stdin; 2013-06-24 07:29:56 EDT LOG: could not send data to client: No connection could be made

because the target machine actively refused it. In the Postgresql Log file the above error shows.

To ignore a table you can use the -T ir_attachment option, and then with -t ir_attachment to only bakcup that table. But I do not see why this will help you

You can drop table attachment then restore again