Manually restoring db

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Manually restoring db

Postby reckless » Tue Jul 19, 2011 4:52 am

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?
reckless
 
Posts: 5
Joined: Sun Jul 17, 2011 2:22 pm

Re: Manually restoring db

Postby reckless » Tue Jul 19, 2011 6:12 am

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)
reckless
 
Posts: 5
Joined: Sun Jul 17, 2011 2:22 pm

Re: Manually restoring db

Postby reckless » Tue Jul 19, 2011 7:45 am

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 :(
reckless
 
Posts: 5
Joined: Sun Jul 17, 2011 2:22 pm

Re: Manually restoring db

Postby kraada » Tue Jul 19, 2011 9:15 am

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)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin