Page 1 of 1

Manually restoring db

PostPosted: Tue Jul 19, 2011 4:52 am
by reckless
I reinstalled my os today to win7x64 (from x86). I forgot to do any backuping through pgAdmin so im left only with data folder.. Postgres version was 8.3 and now i installed 9. Is there any chance i can bring my old db back?

Re: Manually restoring db

PostPosted: Tue Jul 19, 2011 6:12 am
by reckless
Tried just coping 'data' folder instead of 9.0's. Right after that i had to remove some max_fsm line from confing and then i got msg while trying to start service that data folder is from 8.3 and is not compatible with version 9.... Any chance to convert it somehow to 9.0?
Downloaded 8.3 again but cant seem to make it work. 8.3 service is running and 9.0 is down and i can only access 9.0 dummy database :S (pgAdmin)

Re: Manually restoring db

PostPosted: Tue Jul 19, 2011 7:45 am
by reckless
After googling for a while seems that just copying complete data folder and reseting user ownership over files should work.. For me, for some reason, it didnt :(

brb importing 5days non stop again :(

Re: Manually restoring db

PostPosted: Tue Jul 19, 2011 9:15 am
by kraada
If you reinstall 8.3 that data folder should still work - data folders are not compatible across major versions (8.3 to 8.4, 8.4 to 9.0, 9.0 to 9.1, etc)

highfalutin