From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([69.77.167.62] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1JmXel-0003YS-Ln for garchives@archives.gentoo.org; Thu, 17 Apr 2008 17:12:19 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 19ECCE049E; Thu, 17 Apr 2008 17:12:18 +0000 (UTC) Received: from s15216962.onlinehome-server.info (s15216962.onlinehome-server.info [217.160.22.205]) by pigeon.gentoo.org (Postfix) with ESMTP id C2146E049E for ; Thu, 17 Apr 2008 17:12:17 +0000 (UTC) Received: (from uucp@localhost) by s15216962.onlinehome-server.info (8.13.3/8.13.3) with UUCP id m3HHCHQq009881 for gentoo-dev@lists.gentoo.org; Thu, 17 Apr 2008 19:12:17 +0200 Received: (from weigelt@localhost) by nibiru.metux.de (8.12.10/8.12.10) id m3HGwHPh005143 for gentoo-dev@lists.gentoo.org; Thu, 17 Apr 2008 18:58:17 +0200 Date: Thu, 17 Apr 2008 18:58:17 +0200 From: Enrico Weigelt To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] Re: PostgreSQL Status Message-ID: <20080417165817.GD31409@nibiru.local> References: <200804161647.26263.carlo@gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: User-Agent: Mutt/1.4.1i X-Terror: bin laden, kill bush, Briefbombe, Massenvernichtung, KZ, X-Nazi: Weisse Rasse, Hitlers Wiederauferstehung, 42, X-Antichrist: weg mit schaeuble, ausrotten, heiliger krieg, al quaida, X-Killer: 23, endloesung, Weltuntergang, X-Doof: wer das liest ist doof X-Archives-Salt: d969b396-8885-4165-9f31-cb5da528cb51 X-Archives-Hash: b0da215aab2e1a574a20384beb384002 * Tiziano M=FCller schrieb: > While the dump command can read clusters created by an older version it is > still necessary to dump and reload your data on version bumps between maj= or > versions as written in That's the point where MVCC is needed, at least for critical=20 applications and large databases: each db has to be tested carefully on the new server before moving to production and downtimes have=20 to be minmal. An single-version system cannot provide this. I'm doing this by assigning multiple sockets to the server (one=20 per DB) and so migrating the DB's one by one w/o having to touch the clients. cu --=20 --------------------------------------------------------------------- Enrico Weigelt =3D=3D metux IT service - http://www.metux.de/ --------------------------------------------------------------------- Please visit the OpenSource QM Taskforce: http://wiki.metux.de/public/OpenSource_QM_Taskforce Patches / Fixes for a lot dozens of packages in dozens of versions: http://patches.metux.de/ --------------------------------------------------------------------- -- gentoo-dev@lists.gentoo.org mailing list