Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A9487632BCA for ; Wed, 2 Jun 2010 04:18:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 91169-02 for ; Wed, 2 Jun 2010 07:18:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from echo917.server4you.de (echo917.server4you.de [85.25.141.73]) by mail.postgresql.org (Postfix) with ESMTP id F138763266D for ; Wed, 2 Jun 2010 04:18:09 -0300 (ADT) Received: from test.wurger.de (essn-d9bba2d9.pool.mediaWays.net [217.187.162.217]) (authenticated bits=0) by echo917.server4you.de (8.14.2/8.13.6) with ESMTP id o5278c4e027645; Wed, 2 Jun 2010 09:08:43 +0200 Message-ID: <4C0605A6.60803@longimanus.net> Date: Wed, 02 Jun 2010 09:17:58 +0200 From: Andreas Schmitz Reply-To: mailinglist@longimanus.net User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: ALEXANDER JOSE CC: postgres admin Subject: Re: Restore DataBase References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/10 X-Sequence-Number: 34788 hi, sounds like a plain text backup. your problem, I guess, will be some constraint issue. I suggest commenting out the constraints in the backup file before running the restore. regards andreas ALEXANDER JOSE wrote: > psql coon I'm trying to restore a database that has 60 GB in size, > where there is a table with 38 million records, has raised 18 million > records when the restore process fails on a syntax error, the backup > was made with a file. sql as the best way I can do to restore?? > > > Alexander Angel > Venezuela > > ------------------------------------------------------------------------ > Invite your mail contacts to join your friends list with Windows Live > Spaces. It's easy! Try it! >