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>


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to