Timeline for Recover old PostgreSQL database after reinstalling Windows
Current License: CC BY-SA 4.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Aug 28, 2021 at 6:00 | comment | added | MSC | It turns out that it wasn't my old Windows boot drive which had died but the motherboard. Once I discovered this, I was able to boot from that disk instead and run pgAdminIII (on PG 9.4) to backup the database to a file. I then booted from the new Windows drive and was able to restore the file to a blank database in pgAdmin4 running PG 9.6. | |
S Aug 3, 2021 at 15:04 | history | bounty ended | CommunityBot | ||
S Aug 3, 2021 at 15:04 | history | notice removed | CommunityBot | ||
Jul 29, 2021 at 4:54 | comment | added | MSC | I have jumped through a few hoops but still not there yet. I ended up uninstalling 12 and installing 9.4.26 (which is the closest version I can find). The installer wouldn't allow me to install into my old 9.4 folder. I then tried to copy the data folder from 9.4 to 9.4.26 but that errored. The export 9.4 to db.out seemed to work but the file was unexpectedly small. I still need to figure out how to import it into 9.4.26 using command line or pgAdminIII. The page you referred me too is pretty comprehensive but has some odd English which makes it tricky to follow. | |
Jul 26, 2021 at 13:45 | comment | added | harrymc | Follow the article Upgrade PostgreSQL 9.X to 12.X in Windows. Let me know if you have missed out on any of the described steps. be careful, as some of the examples have a spurious space inserted in the middle of the folder name. | |
S Jul 26, 2021 at 13:10 | history | bounty started | MSC | ||
S Jul 26, 2021 at 13:10 | history | notice added | MSC | Authoritative reference needed | |
Jul 24, 2021 at 12:46 | history | asked | MSC | CC BY-SA 4.0 |