Hello, Sometimes I have to maintain two similar database and I have to update one from the other and notice having the option to add ON CONFLICT DO NOTHING clause to INSERT command in the dump data will allows pg_restore to be done with free of ignore error.
The attache patch add --on-conflect-do-nothing option to pg_dump in order to do the above. regards Surafel
pg_dump_onConflect_v1.pach
Description: Binary data