Version 8.2. pg_restore 8.2.4 pg_dump 8.2.4 Info on log file: 2007-08-29 08:46:52 ERROR: duplicate key violates unique constraint "pg_largeobject_loid_pn_index" Regards, Jordi Please fix your mailer to not mangle text like that ... Anyway. I'm wondering about version skew. What PG version is this, and in particular are the pg_restore and server the same version? What shows up in the postmaster log when this happens? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly ____________________________________________________________________________________Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. http://tv.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster