[ADMIN] howto restore from pg_dumpall

2008-03-16 Thread Marc Fromm
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. I find in necessary to wipe the entire data folder and rebuild it with initdb. Is there a

Re: [ADMIN] howto restore from pg_dumpall

2008-03-16 Thread Peter Eisentraut
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