From: | Andreas Schmitz <mailinglist(at)longimanus(dot)net> |
---|---|
To: | ALEXANDER JOSE <aangelj(at)hotmail(dot)com> |
Cc: | postgres admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Restore DataBase |
Date: | 2010-06-02 07:17:58 |
Message-ID: | 4C0605A6.60803@longimanus.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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>
From | Date | Subject | |
---|---|---|---|
Next Message | mario martinez hernandez | 2010-06-02 13:16:41 | Modificar tamaño de pg_xlog |
Previous Message | Szymon Guz | 2010-06-02 06:07:27 | Re: Restore DataBase |