Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 12BA32E2DE4 for ; Sun, 16 Mar 2008 19:06:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 63557-10 for ; Sun, 16 Mar 2008 19:06:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 4B0922E0073 for ; Sun, 16 Mar 2008 19:05:50 -0300 (ADT) Received: (qmail invoked by alias); 16 Mar 2008 22:05:48 -0000 Received: from xdsl-87-79-141-12.netcologne.de (EHLO colt.pezone.net) [87.79.141.12] by mail.gmx.net (mp046) with SMTP; 16 Mar 2008 23:05:48 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX19jzJQZy+ljRHEDKO/BeLPZ6Ywvc5R/YU2kr6FC34 6fwk6tLs5btFRp From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: howto restore from pg_dumpall Date: Sun, 16 Mar 2008 23:05:44 +0100 User-Agent: KMail/1.9.7 Cc: "Marc Fromm" References: <81FEAB8CDDC62B42B6E8AA258228BC88047417DA@EVS2.univ.dir.wwu.edu> In-Reply-To: <81FEAB8CDDC62B42B6E8AA258228BC88047417DA@EVS2.univ.dir.wwu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803162305.45936.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/120 X-Sequence-Number: 28603 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.