Thread: Restore DataBase
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
Alexander Angel
Venezuela
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it!
2010/6/2 ALEXANDER JOSE <aangelj@hotmail.com>
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
How did you make the backup?
regards
Szymon Guz
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>
On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE <aangelj@hotmail.com> wrote:
It will be easier for people to help if you provide more info such as postgres version, OS, how the backup was made, exact error message, etc. But, if you're getting a syntax error, then my best guess would be that either that you have a corrupt/incomplete backup, or that you're trying to restore to a different version of postgres than you used to make the backup, and the backup has syntax which would be valid for the version that made it, but not for the version you're trying to restore to.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??
-Eric