Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0A86D9F9A34 for ; Mon, 15 Oct 2007 10:04:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 93056-07 for ; Mon, 15 Oct 2007 10:04:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 291139F98F6 for ; Mon, 15 Oct 2007 10:04:16 -0300 (ADT) Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) by is.rice.edu (Postfix) with ESMTP id BA84D41894; Mon, 15 Oct 2007 08:04:14 -0500 (CDT) Received: from is.rice.edu ([128.42.42.24]) by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) (amavisd-new, port 10024) with ESMTP id 25306-08; Mon, 15 Oct 2007 08:04:14 -0500 (CDT) Received: by is.rice.edu (Postfix, from userid 18612) id 0A0D941893; Mon, 15 Oct 2007 08:04:13 -0500 (CDT) Date: Mon, 15 Oct 2007 08:04:13 -0500 From: Kenneth Marshall To: Alexander Kuprijanov Cc: pgsql-admin@postgresql.org, "Milen A. Radev" Subject: Re: How to update from 8.1 to 8.2 ? Message-ID: <20071015130413.GT12467@it.is.rice.edu> References: <46F294F1.50004@joops.com> <200710151652.43409.sanya-spb@list.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200710151652.43409.sanya-spb@list.ru> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/116 X-Sequence-Number: 27030 Use Slony to replicate to the new version from the old version. Once they are sync-ed up, you switch the new version to be the master and re-point your apps to the new DB. Ken On Mon, Oct 15, 2007 at 04:52:43PM +0400, Alexander Kuprijanov wrote: > Hello > > Does exist another way to make upgrade (without dump-restore)? > > I have this question, because I have very big DB (or very poor server): dump > ~40min, restore >2h > > I can't stop my DB so long... > > > > Thanks > > > ?? ?????????????????? ???? Thursday 20 September 2007 19:58:24 Milen A. Radev ??????????????(??): > > Josef Springer ????????????: > > > Where is the documentation of the steps dto do for updating e.g. from 8.1 > > > to 8.2 ? I have never done this and could not find any docs for. > > > > [...] > > > > http://www.postgresql.org/docs/8.2/static/install-upgrading.html > > > > -- > Se okulo ne atentas, dorso eksentas > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >