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