Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id DA3CEABB2F9 for ; Sat, 14 Jul 2012 00:31:37 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Spt4s-0003NB-K4 for pgsql-sql@postgresql.org; Sat, 14 Jul 2012 03:31:35 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1Spt4f-0000lI-Se for pgsql-sql@postgresql.org; Sat, 14 Jul 2012 05:31:18 +0200 Received: from ip-118-90-70-161.xdsl.xnet.co.nz ([118.90.70.161]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 14 Jul 2012 05:31:17 +0200 Received: from jasen by ip-118-90-70-161.xdsl.xnet.co.nz with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 14 Jul 2012 05:31:17 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Jasen Betts Subject: Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas) Date: 14 Jul 2012 03:22:07 GMT Organization: Dis (not Dat) Organisation Lines: 16 Message-ID: References: <4FEE0DCB.8020503@gmail.com> <3EED475E754849429C74FCAB58B57CFF@chrisp> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: ip-118-90-70-161.xdsl.xnet.co.nz X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s; a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W; (T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q; 8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^ User-Agent: slrn/pre1.0.0-18 (Linux) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/15 X-Sequence-Number: 36752 On 2012-07-10, Chris Preston wrote: > > Hello all, > How far can I get to a higher version of PostgreSQL by just entering a > command line instruction to upgrade without any major effort? 8.1.23 going to 8.2.x or later is going to need more effort, especially if any of your code relies on any of 8.1's quirks (like comparing integers to strings) - if you do decide to abandon 8.1.x you may as well make it a big change and go to 9.1 -- ⚂⚃ 100% natural