Hello I did on the same server / cluster ( 8.0.1 / ISO-8859-8 ) pg_dump -Fc sourcedb > sourcedb-Fc.dump pg_dump -a sourcedb > sourcedb.dump createdb test pg_restore -c -s -d test sourcedb-Fc.dump psql test < sourcedb.dump I got few errors ( here are some of them ): ERROR: insert or update on table "logo_product" violates foreign key constraint "logo_product_product_id_fkey" DETAIL: Key (product_id)=(2) is not present in table "product". ERROR: insert or update on table "order_coupon" violates foreign key constraint "order_coupon_redeem_order_id_fkey" DETAIL: Key (redeem_order_id)=(3) is not present in table "orders". ERROR: insert or update on table "order_product" violates foreign key constraint "order_product_order_id_fkey" DETAIL: Key (order_id)=(3) is not present in table "orders". ERROR: insert or update on table "order_product_property" violates foreign key constraint I checked the source DB and it has a product with (product_id)=(2) Whats wrong, is pg_dump so unreliable ? I want to dump 8.0.1 databases and move them to a newer server / cluster. but its impossible if pg_dump not dumping accurate data. Thanks for the help Miki -- -------------------------------------------------- Michael Ben-Nes - Internet Consultant and Director. http://www.epoch.co.il - weaving the Net. Cellular: 054-4848113 --------------------------------------------------
