X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E073D5E46EB for ; Tue, 24 Aug 2004 13:36:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57435-06 for ; Tue, 24 Aug 2004 16:36:22 +0000 (GMT) Received: from web40710.mail.yahoo.com (web40710.mail.yahoo.com [66.218.78.167]) by svr1.postgresql.org (Postfix) with SMTP id 0E8825E3631 for ; Tue, 24 Aug 2004 13:36:10 -0300 (ADT) Message-ID: <20040824163618.39059.qmail@web40710.mail.yahoo.com> Received: from [200.163.192.124] by web40710.mail.yahoo.com via HTTP; Tue, 24 Aug 2004 13:36:18 ART Date: Tue, 24 Aug 2004 13:36:18 -0300 (ART) From: "=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?=" Subject: Re: [GENERAL] Dump and Restore To: Paul Thomas Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org In-Reply-To: <20040824162956.D17786@bacon> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.4 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL, RCVD_IN_NJABL_PROXY, RCVD_IN_SORBS_MISC X-Spam-Level: ** X-Archive-Number: 200408/232 X-Sequence-Number: 14627 I am using pg_dump. It means that I can't restore to a different name database?? Eduardo S. Fontanetti --- Paul Thomas escreveu: > > On 24/08/2004 14:40 Eduardo S. Fontanetti wrote: > > How can I do a test if my dumping is really > working, I > > can't apply the dump in my database, because it > will > > overwrite a lot of data. I was thinking about > restore > > in another database name, but I can't, it always > > restore on the original database. > > > > Somebody have a cooking recipe about to test if my > > backup is working fine, and will help if I need > > sometime? > > Are you using pg_dump or pg_dumpall? I just use > pg_dump on individual > databases (pg_dumpall works on the whole cluster) > and can restore that to > any database. > > > HTH > > -- > Paul Thomas > +------------------------------+---------------------------------------------+ > | Thomas Micro Systems Limited | Software Solutions > for > Business | > | Computer Consultants | > http://www.thomas-micro-systems-ltd.co.uk | > +------------------------------+---------------------------------------------+ > _______________________________________________________ Yahoo! Acesso Grátis - navegue de graça com conexão de qualidade! http://br.acesso.yahoo.com/