Marc Fromm wrote: > When I restore from a pg_dumpall file, I am required to peform the > following steps or else all the records in the databses are duplicated. If > I only empty the data/base folder I get al sorts of errors. You may find the pg_dumpall --clean option useful, so the dump file is set up in a way that cleans out its predecessor objects automatically. Otherwise you will have to find your own to way clean up before restoring. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin