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 1Jm8vB-00015z-2J for garchives@archives.gentoo.org; Wed, 16 Apr 2008 14:47:37 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id CD098E086F; Wed, 16 Apr 2008 14:47:35 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id A9779E086F for ; Wed, 16 Apr 2008 14:47:35 +0000 (UTC) Received: from iglu.bnet.local (e177163155.adsl.alicedsl.de [85.177.163.155]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTP id 2AD326688D for ; Wed, 16 Apr 2008 14:47:35 +0000 (UTC) From: Carsten Lohrke To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] PostgreSQL Status Date: Wed, 16 Apr 2008 16:46:38 +0200 User-Agent: KMail/1.9.7 References: In-Reply-To: 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: multipart/signed; boundary="nextPart1667248.f0HSN4KDVA"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200804161647.26263.carlo@gentoo.org> X-Archives-Salt: 8ded59ed-8b5d-420a-bea0-ed5c446d5594 X-Archives-Hash: e3f6c56e09c42a8116e94c6d89708ca8 --nextPart1667248.f0HSN4KDVA Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline > c) Upgrading between major versions of PostgreSQL requires the DB admin to > bump the database using the old version, moving the database away and to > reload the dump into a new database cluster using the new version of > 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 make the > upgrade easier. As I read upstream's documentation=B9, this is incorrect: # It is recommended that you use the pg_dump and pg_dumpall programs from t= he # newer version of PostgreSQL, to take advantage of any enhancements that m= ay # have been made in these programs. Current releases of the dump programs c= an # read data from any server version back to 7.0.=20 This has also been pointed out in a bug report, duped by some overzealous b= ug=20 wrangler a few months ago. > What do the new ebuilds offer: > a) A split into dev-db/postgresql-{base,server,docs}. Now, I know that > splitting up packages isn't the Gentoo way. I know we could have done it > using USE flags but this approach gives more flexibility due to the curre= nt > way how binary packages are being generated and distributed. I wouldn't say so. Needlessly growing the forest of odd named, badly=20 documented and sometimes needlessly added use flags is something I'm not fo= nd=20 of, looking at the development of Gentoo. Thanks to everyone taking care of our PostgreSQL packages. Carsten [1] http://www.postgresql.org/docs/8.2/interactive/migration.html --nextPart1667248.f0HSN4KDVA Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.7 (GNU/Linux) iD8DBQBIBhF+VwbzmvGLSW8RAionAJwIJIFPxHSu2L3Laq9ZD4n2qqRy1wCgoq8u EIHVpmhVg9GVnjDBGon+hnk= =3UA+ -----END PGP SIGNATURE----- --nextPart1667248.f0HSN4KDVA-- -- gentoo-dev@lists.gentoo.org mailing list