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 1JmAJl-0007my-J5 for garchives@archives.gentoo.org; Wed, 16 Apr 2008 16:17:07 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id BF2ADE0401; Wed, 16 Apr 2008 16:17:03 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 997B9E0401 for ; Wed, 16 Apr 2008 16:17:03 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by smtp.gentoo.org (Postfix) with ESMTP id 48D1D64B6C for ; Wed, 16 Apr 2008 16:17:03 +0000 (UTC) X-Virus-Scanned: amavisd-new at gentoo.org X-Spam-Score: -2.409 X-Spam-Level: X-Spam-Status: No, score=-2.409 required=5.5 tests=[AWL=1.190, BAYES_00=-2.599, RCVD_IN_DNSWL_LOW=-1] Received: from smtp.gentoo.org ([127.0.0.1]) by localhost (smtp.gentoo.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UJHrEdlb2Wpc for ; Wed, 16 Apr 2008 16:16:56 +0000 (UTC) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTP id 74D1064279 for ; Wed, 16 Apr 2008 16:16:54 +0000 (UTC) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JmAJP-0005x6-24 for gentoo-dev@gentoo.org; Wed, 16 Apr 2008 16:16:45 +0000 Received: from gw.ptr-80-238-131-106.customer.ch.netstream.com ([80.238.131.106]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 16 Apr 2008 16:16:43 +0000 Received: from dev-zero by gw.ptr-80-238-131-106.customer.ch.netstream.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 16 Apr 2008 16:16:43 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: gentoo-dev@lists.gentoo.org From: Tiziano =?ISO-8859-1?Q?M=FCller?= Subject: [gentoo-dev] Re: PostgreSQL Status Date: Wed, 16 Apr 2008 18:16:31 +0200 Organization: Gentoo Message-ID: 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 X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: gw.ptr-80-238-131-106.customer.ch.netstream.com User-Agent: KNode/0.10.9 Sender: news Content-Transfer-Encoding: quoted-printable X-Archives-Salt: 6bc5f6bf-4756-40cd-9c0f-0ab80a162111 X-Archives-Hash: 598b65361dace2c332c17636d420985f Carsten Lohrke wrote: >> c) Upgrading between major versions of PostgreSQL requires the DB admi= n >> to bump the database using the old version, moving the database away a= nd >> to reload the dump into a new database cluster using the new version o= f >> PostgreSQL. Having to take down the old server and purging the old >> version of PostgreSQL before being able to try out the new one is more >> than cumbersome. Therefore a slotted postgresql-server is needed to ma= ke >> the upgrade easier. >=20 > As I read upstream's documentation=B9, this is incorrect: >=20 > # It is recommended that you use the pg_dump and pg_dumpall programs fr= om > # the newer version of PostgreSQL, to take advantage of any enhancement= s > # that may have been made in these programs. Current releases of the du= mp > # programs can read data from any server version back to 7.0. While the dump command can read clusters created by an older version it i= s still necessary to dump and reload your data on version bumps between maj= or versions as written in http://www.postgresql.org/docs/8.3/static/install-upgrading.html: [...] The internal data storage format typically changes in every major release= of PostgreSQL. Therefore, if you are upgrading an existing installation that does not have a version number of "8.3.x", you must back up and restore your data. If you are upgrading from PostgreSQL "8.3.x", the new version can use your current data files so you should skip the backup and restore steps below because they are unnecessary. [...] Cheers, Tiziano --=20 gentoo-dev@lists.gentoo.org mailing list