Re: Restore DataBase - Mailing list pgsql-admin

From Andreas Schmitz
Subject Re: Restore DataBase
Date
Msg-id 4C0605A6.60803@longimanus.net
Whole thread Raw
In response to Restore DataBase  (ALEXANDER JOSE <aangelj@hotmail.com>)
List 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>


pgsql-admin by date:

Previous
From: Tena Sakai
Date:
Subject: Re: What is field separator?
Next
From: Manohar Bhattarai
Date:
Subject: Exception while accessing database