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.