Hi,
I have a simple question that I can't find the answer to in the
documentation: how do I backup & restore a single database, ie. when
going from one cluster to another? I'm fairly comfortable with the
command line so I can create and restore backups but things do not
always work as expected.
pg_dump -U postgres -f my_database.dmp -F c my_database
now I want to restore this database to another system where a
database with the same name already exists (from production to
development):
According to the documentation the options -c and -a can be set on
pg_restore
ie.,
pg_restore -U postgres -c -d psytec psytec.dmp
should drop all the tables before recreating them but I get a load of
errors:
pg_restore: [archiver (db)] Error from TOC entry 1949; 2620 297386
TRIGGER RI_ConstraintTrigger_297386 postgres
using -a to restore data only means fewer errors as pg_restore exits
on the first error
Is the only way to drop the target database and recreate an empty
one? Or am I simply misreading the docs?
Thanks very much for any help.
Charlie
--
Charlie Clark
Helmholtzstr. 20
Düsseldorf
D- 40215
Tel: +49-211-938-5360
GSM: +49-178-782-6226
