hello, I use an automated script that if it detects a problem in a database uses a dumb from another db to recover data. 'pg_dump -c -h host1 d1 | psql -a -h host2 -d db2 >> recover_dump 2>&1' now my recover_dump tells me a unix index could`nt be created as the table contains duplicated keys. My guess is the data there was data inserted by the application while the restore was inserting data and the constraints where not set. This seems possible to me as there is no LOCK statement in the dump. So actually I m searching for a way to tell the target db not to take any connections while restoring but also wonder if I in future have to take more action to protect databases I dump --clean dumps to. debian sarge psql (PostgreSQL) 7.4.7
