Stuff too big to tweet, not big enough to blog.

18th December 2009

Photo with 1 note

I’m at Local 123 cafe with my buddy jch (coffee is excellent here, btw), and just completed a db migration to postgresql 8.4.2 from 8.2.13. Thing is, I didn’t upgrade on production— I recovered to a failover server, then switched to make the other postgres the primary. So now caffeinatedcode.com is working on a true two-tier setup.It was interesting to test a backup-recovery, and I am glad to see that it is relatively painless to do so. There’s a lot of fear when upgrading, especially when skipping ahead two major revisions. Who knows what they changed. In this case, it was good to work with parallel db’s and hardly any downtime at all.

I’m at Local 123 cafe with my buddy jch (coffee is excellent here, btw), and just completed a db migration to postgresql 8.4.2 from 8.2.13. Thing is, I didn’t upgrade on production— I recovered to a failover server, then switched to make the other postgres the primary. So now caffeinatedcode.com is working on a true two-tier setup.

It was interesting to test a backup-recovery, and I am glad to see that it is relatively painless to do so. There’s a lot of fear when upgrading, especially when skipping ahead two major revisions. Who knows what they changed. In this case, it was good to work with parallel db’s and hardly any downtime at all.

  1. caffeinatedcode posted this