On Mon, Jan 26, 2009 at 12:27 PM, Jeff <threshar@xxxxxxxxxxxxx> wrote: > I'm quite excited about the feature. I'm still on 8.2 mostly because of the > downtime of the dump & restore. I wrote up some plans a while back on doing > the poor-mans parallel restore, but I haven't had the time to actually do > it. We use slony to provide read-only copies of the database for reporting purposes and any other queries that it's OK to serve data that may be slightly stale. We also have used it to upgrade our 15GB database with only a few minutes of downtime instead of the minimum 2 hours it takes to do a dump/restore. Slony works with any version of Postgres going back to versions before 8.1 (anyone still use Postgres that old?). If you get all your ducks in a row, you can get upgraded with only seconds of downtime, though realistically it takes a bit longer. http://slony.info/documentation/versionupgrade.html -Dave -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
