News for hackers. Stuff that matters.
Re:Postgres 9.2 will feature linear read scalability up to 6... by einhverfr on Wednesday April 04, 2012 @06:12AM (#3796892)
Look into pg_upgrade.
Re:Postgres 9.2 will feature linear read scalability up to 6... by vidarh on Wednesday April 04, 2012 @07:48AM (#3797101)
It still requires the server to be taken down during the upgrade, and has a bunch of limitations that means it's still more cost effective for us to spend a few days on ugly custom hacks to avoid the pain.
Re:Postgres 9.2 will feature linear read scalability up to 6... by fdr on Wednesday April 04, 2012 @04:07PM (#3799578)
The most obvious balm is a logical replication solution. Unfortunately those require non-trivial implementation, but it's something that is in its broad generalities not controversial for inclusion.

Dimitri Fontaine has posted a large patch to implement a devilish component of that, DDL/Command triggers, receiving a lot of detailed review and attention: https://commitfest.postgresql.org/action/patch_view?id=768

But I think a cohesive solution can only be realistically realized in releases >= 9.3.