From quzhengping@gmail.com Mon Sep 8 03:45:58 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E81A564FD16 for ; Mon, 8 Sep 2008 00:45:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10190-10 for ; Mon, 8 Sep 2008 00:45:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229]) by postgresql.org (Postfix) with ESMTP id D625064FCE6 for ; Mon, 8 Sep 2008 00:45:43 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id i26so66859wxd.28 for ; Sun, 07 Sep 2008 20:45:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type; bh=ytCGOWpBq3TFkDeIVOsOLGIOlvqjd7o7uvEjyb2JWk8=; b=Ff7m66no8AzkvztJX6m2Y3y7T0Ff7OZ9HczMONwjhPOj+4ccFLHqmRVhcgyBxYwvLK jO28EQIumLm/8wON4Z8Whsl5cK5DAseW2i/HsKtseAIWTt9p1ej3S6A/yQ8kEUm7TpPq eoTdJJYNVvFdDq7gVdvFukl5/U5rX6CK0+ZjE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=ayPTY9wlFZrdlvbsRKwmAuutzL8R83SczwkecoXeycRG8YrnFNFpUT3DQBjeUodUhy YRhcOdLIMUV0+CBrXdFcSs5Jft30/Gjcg9x/SgzzCIAXU7B58lznK7XiC/ZkMMX3Fv0S xbBFUR+X9MzEck2RbSseuxxcY4ZfQT5dbRbhs= Received: by 10.70.47.19 with SMTP id u19mr18471976wxu.49.1220844943120; Sun, 07 Sep 2008 20:35:43 -0700 (PDT) Received: by 10.70.46.2 with HTTP; Sun, 7 Sep 2008 20:35:43 -0700 (PDT) Message-ID: Date: Mon, 8 Sep 2008 11:35:43 +0800 From: Jumping To: pgsql-admin@postgresql.org Subject: update to 8.3.3 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_70040_10306363.1220844943132" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/58 X-Sequence-Number: 30151 ------=_Part_70040_10306363.1220844943132 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi,all! I plan to update my database from 8.1.9 to 8.3.3. Is there any tricks or tips ? Thanks in advance. -- Don't tell me how many the enemies,but where they are! (ADV:Perl -- It's like Java, only it lets you deliver on time and under budget.) ------=_Part_70040_10306363.1220844943132 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi,all!
    I plan to update my database from 8.1.9 to 8.3.3.
    Is there any tricks or tips ?
    Thanks in advance.

--
Don't tell me how many the enemies,but where they are!
(ADV:Perl -- It's like Java, only it lets you deliver on time and under budget.)
------=_Part_70040_10306363.1220844943132-- From devrim@gunduz.org Mon Sep 8 13:13:47 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 688926500A8 for ; Mon, 8 Sep 2008 10:13:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19646-02 for ; Mon, 8 Sep 2008 10:13:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from orion.asenkron.com (orion.asenkron.com [64.15.152.21]) by postgresql.org (Postfix) with ESMTP id 8CE5165007C for ; Mon, 8 Sep 2008 10:13:40 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by orion.asenkron.com (Postfix) with ESMTP id 89809BD0004; Mon, 8 Sep 2008 13:09:03 +0000 (UTC) X-Virus-Scanned: amavisd-new at orion.asenkron.com Received: from orion.asenkron.com ([127.0.0.1]) by localhost (orion.asenkron.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id enhpljpREEMy; Mon, 8 Sep 2008 16:09:02 +0300 (EEST) Received: from [192.168.1.3] (unknown [88.242.110.187]) by orion.asenkron.com (Postfix) with ESMTPA id B56A2BD0003; Mon, 8 Sep 2008 16:09:01 +0300 (EEST) Subject: Re: update to 8.3.3 From: Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= To: Jumping Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-R3yd2CBPiqbpAXvohFL0" Date: Mon, 08 Sep 2008 16:14:29 +0300 Message-Id: <1220879669.2711.28.camel@laptop.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 (2.22.3.1-1.fc9) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/63 X-Sequence-Number: 30156 --=-R3yd2CBPiqbpAXvohFL0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote: > I plan to update my database from 8.1.9 to 8.3.3. > Is there any tricks or tips ? I would first update to 8.1.13, then go on. Anysay, Read the release notes, and check for any possible incompatibility issues.=20 http://www.postgresql.org/docs/current/static/release-8-3.html http://www.postgresql.org/docs/current/static/release-8-2.html I believe you should first check the casting changes in 8.3 . Regards, --=20 Devrim G=C3=9CND=C3=9CZ, RHCE devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org --=-R3yd2CBPiqbpAXvohFL0 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkjFJTQACgkQtl86P3SPfQ5bxgCeKDiQ9IJNwfHfZepA+mzqxNDt aYkAoOp+VPdyh/jwkO+QvyxbRu0uWrX3 =6JXK -----END PGP SIGNATURE----- --=-R3yd2CBPiqbpAXvohFL0-- From achill@matrix.gatewaynet.com Mon Sep 8 13:21:28 2008 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 30F296500B4 for ; Mon, 8 Sep 2008 10:21:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20328-07 for ; Mon, 8 Sep 2008 10:21:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by postgresql.org (Postfix) with ESMTP id 2DADD650080 for ; Mon, 8 Sep 2008 10:21:21 -0300 (ADT) Received: from smadev.internal.net (localhost [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id m88DLEg9000716; Mon, 8 Sep 2008 16:21:14 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id m88DLAro000715; Mon, 8 Sep 2008 16:21:10 +0300 (EEST) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: update to 8.3.3 Date: Mon, 8 Sep 2008 16:20:38 +0300 User-Agent: KMail/1.9.7 Cc: Devrim =?utf-8?q?G=C3=9CND=C3=9CZ?= , Jumping References: <1220879669.2711.28.camel@laptop.gunduz.org> In-Reply-To: <1220879669.2711.28.camel@laptop.gunduz.org> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200809081621.10713.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/64 X-Sequence-Number: 30157 =CE=A3=CF=84=CE=B9=CF=82 Monday 08 September 2008 16:14:29 =CE=BF/=CE=B7 De= vrim G=C3=9CND=C3=9CZ =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > On Mon, 2008-09-08 at 11:35 +0800, Jumping wrote: > > I plan to update my database from 8.1.9 to 8.3.3. > > Is there any tricks or tips ? >=20 > I would first update to 8.1.13, then go on. Hehe i upgraded from 7.4 to 8.3.3 and it was a big pain, but since i survived i'd say 8.1.9->8.3.3 is at least safe! It all depends on the quality (standard-wise) of the original SQL code howe= ver. >=20 > Anysay, Read the release notes, and check for any possible > incompatibility issues.=20 >=20 > http://www.postgresql.org/docs/current/static/release-8-3.html > http://www.postgresql.org/docs/current/static/release-8-2.html >=20 > I believe you should first check the casting changes in 8.3 . >=20 > Regards, =2D-=20 Achilleas Mantzios