awesome! On Thu, May 17, 2012 at 6:37 AM, Stuart Bishop <stuart.bis...@canonical.com> wrote: > Hi. > > We just cut the master Launchpad database over to PostgreSQL 9.1, and > all Launchpad systems are now dealing only with PostgreSQL 9.1 > systems. > > The old master will remain unused but live for another few hours along > with the unmigrated slave running PostgreSQL 8.4 allowing us to easily > rollback to 8.4 if any major hiccups happen. Things look fine so far > though, and the old 8.4 master database will be dropped before the > weekend for disk space reasons. > > Next on the PostgreSQL infrastructure agenda for Launchpad is > replacing Slony with PostgreSQL streaming replication, available out > of the box since PostgreSQL 9.0. This will simplify our production > environment and make fast downtime deployments faster. It also allows > us to use synchronous replication, an option for making our load > balancing more efficient. I'll be looking at this once we have moved > more of the Canonical systems over to PostgreSQL 9.1. > > I expect Launchpad applications to benefit greatly from the update, > immediately from planner improvements and in the very near future by > being able to replace our GiST indexes with GIN indexes speeding up > our text search. It also paves the way to updating the database > servers to 11.04. > > -- > Stuart Bishop <stuart.bis...@canonical.com> > > -- > Postgresql-support mailing list > postgresql-supp...@lists.canonical.com > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/postgresql-support
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : launchpad-dev@lists.launchpad.net Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
