topic Error by restoring postgresql database in Server Management - Systems Insight Manager https://community.hpe.com/t5/server-management-systems/error-by-restoring-postgresql-database/m-p/4083893#M29650 Hello,<BR />I am dumping our database daily from sim by subject matter the document 'sim5.1_backup_restore.pdf'.<BR />But when I restore the database:<BR />/usr/bin/dropdb -p 5432 -h 127.0.0.1 -i -e insight_v1_0<BR />/usr/bin/createdb -O postgres -h 127.0.0.1 -p 5432 -U postgres insight_v1_0<BR />/usr/bin/psql -q -h 127.0.0.1 -U mxadmin -p 5432 -f /home/backup/saveHPSIMdb_20071010010002 -d insight_v1_0<BR /><BR />following error occured:<BR />"psql:/home/backup/saveHPSIMdb_20071010010002:320168: FEHLER: konnte Unique Index nicht erstellen<BR />DETAIL: Tabelle enthält duplizierte Werte.<BR />"<BR /><BR />But the applikation of sim works fine after the restore!!!<BR />Why I have the error of duplicate values?<BR />I have droped the database and created a new db...<BR /><BR />Thanks<BR />kind regards<BR /><BR />Udo Hillenbrand Wed, 10 Oct 2007 08:27:38 GMT Udo Hillenbrand 2007-10-10T08:27:38Z Error by restoring postgresql database https://community.hpe.com/t5/server-management-systems/error-by-restoring-postgresql-database/m-p/4083893#M29650 Hello,<BR />I am dumping our database daily from sim by subject matter the document 'sim5.1_backup_restore.pdf'.<BR />But when I restore the database:<BR />/usr/bin/dropdb -p 5432 -h 127.0.0.1 -i -e insight_v1_0<BR />/usr/bin/createdb -O postgres -h 127.0.0.1 -p 5432 -U postgres insight_v1_0<BR />/usr/bin/psql -q -h 127.0.0.1 -U mxadmin -p 5432 -f /home/backup/saveHPSIMdb_20071010010002 -d insight_v1_0<BR /><BR />following error occured:<BR />"psql:/home/backup/saveHPSIMdb_20071010010002:320168: FEHLER: konnte Unique Index nicht erstellen<BR />DETAIL: Tabelle enthält duplizierte Werte.<BR />"<BR /><BR />But the applikation of sim works fine after the restore!!!<BR />Why I have the error of duplicate values?<BR />I have droped the database and created a new db...<BR /><BR />Thanks<BR />kind regards<BR /><BR />Udo Hillenbrand Wed, 10 Oct 2007 08:27:38 GMT https://community.hpe.com/t5/server-management-systems/error-by-restoring-postgresql-database/m-p/4083893#M29650 Udo Hillenbrand 2007-10-10T08:27:38Z