Skip to content

PostgreSQL upgrade from 8.1 to 9.1

Been trying for a while to upgrade a really old database with a really new one, with no downtime , this I managed successfully with Slony-I . with slony 2 its is not possible to go from such an old version of PostgreSQL unfortunately, However Slony 1 worked great  pretty much first time. The only fiddly and long process is setting up the slon_tools.conf file to identify all the table and sequence you need to replicate on your new shiny 9.1 release.I originally successfully replicated to 9.0 as well BTW.

The PostgreSQL 9 release allowed me to also test its own streaming replication , this meant that actually both master & slave of PostgreSQL 9.x needs to be up and running before migrating and replicating from 8.1 with slony 1. Got that tip from @DevrimGunduz himself no less.

Its actually not that difficult , Luckily for me If I mess up (not that I did as it happens!) I have all the power of VMWare to go back to an older snapshot.

 

 

Post a comment — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Monday, September 26, 2011, at 3:11 pm by Ejber. Filed in News.
  • mick winnett

    Looks scary, How big was that database? I’m learning to use MySQL at the moment….and I have it running on an old obsolete pc in ClearOS

    well at least it’s not Microsoft.

  • http://www.ozkan.co.uk Ejber

    Oh around 200 gig ( including old indexes)
    Its not that scary but there a mixed instructions and guides that can confuse.
    I wont comment on MySQL ..except for just saying good luck! .;)