From: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump and errors |
Date: | 2004-05-31 10:49:51 |
Message-ID: | 00c001c446fc$fffa6780$0600000a@mikislap |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Im getting strange errors when restoring data from pg_dump files:
ERROR: duplicate key violates unique constraint "products_pkey"
CONTEXT: COPY products, line 1: "98 Super Pak Ruby játék J-0001 1502450E Szuper Pokémon ajándékcso..."
ERROR: duplicate key violates unique constraint "attributes_pkey"
CONTEXT: COPY attributes, line 1: "2 Width"
ERROR: duplicate key violates unique constraint "prod_attributes_pkey"
CONTEXT: COPY prod_attributes, line 1: "1038 23 12 "
ERROR: duplicate key violates unique constraint "prod_images_pkey"
CONTEXT: COPY prod_images, line 1: "73 14 \\377\\330\\377\\340\\000\\020JFIF\\000\\001\\001\\001\\000H\\000H\\000\\000\\377\\333\\000C\\..."
ERROR: duplicate key violates unique constraint "manufacturer_images_pkey"
CONTEXT: COPY manufacturer_images, line 1: "296 81 \\377\\330\\377\\340\\000\\020JFIF\\000\\001\\001\\001\\000H\\000H\\000\\000\\377\\376\\000&F..."
Im using pg 7.4.1 on woody ( debian ).
this is not the first time such hapens and i have a constant fear from backup failures.
once I even had to move a db from 7.3 to 7.4 and pg_dump returned me some errors on not existing tables ( ones which i deleted before )
this is the line i use ( i started to seperate the scheme from the data becouse its easier to me to edit the files if something happens )
/usr/bin/pg_dump -s -f /var/pg_dumps/db1 db1
/usr/bin/pg_dump -a -f /var/pg_dumps/db1 db1
Any ideas how to avoid such errors ( if possible at all ) ?
Thanks
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2004-05-31 13:09:55 | ODBC, ADO, Return Value from SP problem |
Previous Message | zuhans@iname.com | 2004-05-31 08:36:56 | confused by superuser-definition |