PDA

View Full Version : Problem with restoring database



waytogo
02-21-2011, 07:07 AM
So I follow the guide, start a new database in the way the faq says but I just get this:

"C:\Program Files (x86)\PostgreSQL\8.3\bin\pg_restore.exe -h localhost -p 5432 -U postgres -d "Komigennunfunka" -v "C:\Users\Moneynob\Desktop\BackupHEM.backup"
pg_restore: [archiver] unsupported version (1.11) in file header

Process returned exit code 1."

And in holdem manager I cant even see that database in database management.

I can sen someone of you my backup file if needed.

Patvs
02-21-2011, 07:17 AM
Did you create the backup with SQL 8.3, and are trying to restore it on a computer that has SQL 8.4?

The SQL versions need to be to same, as 8.3 is not compatible with 8.4

waytogo
02-21-2011, 07:53 AM
Did you create the backup with SQL 8.3, and are trying to restore it on a computer that has SQL 8.4?

The SQL versions need to be to same, as 8.3 is not compatible with 8.4

Ty, that was the problem, its now in the procces of restoring, how long time will the restore procces usually take on a large database? And the Pg admin and restore window is frozen is that normal?

netsrak
02-21-2011, 09:43 AM
The froze is normal - its just working hard....


Hard to give you a time, it depends on so many factors. From under 1 hour up to a day.