Infor Gates <info_gates@xxxxxxxxx> writes: > I hope you could help me understand the error message below: > While it looks straight forward, I could NOT find the duplicate key violation, Considering that it's complaining at the very first line of COPY data, I wonder whether you aren't restoring into a table that already contains the data you want to load. pg_restore doesn't (by default) try to delete data that's already present. regards, tom lane