From: Andreas Schmitz <mailinglist@longimanus.net>
To: ALEXANDER JOSE <aangelj@hotmail.com>
Cc: postgres admin <pgsql-admin@postgresql.org>
Subject: Re: Restore DataBase
Date: Wed, 02 Jun 2010 09:17:58 +0200
Message-ID: <4C0605A6.60803@longimanus.net> (raw)
In-Reply-To: <BAY148-w60FE976A729A6DCE9F101CA5D00@phx.gbl>
References: <BAY148-w60FE976A729A6DCE9F101CA5D00@phx.gbl>
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!
> <http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mailinglist@longimanus.net, aangelj@hotmail.com
Subject: Re: Restore DataBase
In-Reply-To: <4C0605A6.60803@longimanus.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox