Hi,
I've set up a secondary server and want to keep the db updated with a
combination of pgdump and rsync. Here's what I do:
pgdump -a mydb > mydb.pgdump
cat mydb.pgdump | psql mydb
which results in several "Cannot insert a duplicate key into unique index"
errors. What's the best way to overwrite existing data without a
dropdb+createdb etc?
Thanks in advance,
Lisa