| 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: | Whole Thread | Raw Message | 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 |