Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9E5E72E003A for ; Tue, 13 May 2008 03:49:03 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42575-09 for ; Tue, 13 May 2008 03:48:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.155]) by developer.postgresql.org (Postfix) with ESMTP id 0B3C12E0039 for ; Tue, 13 May 2008 03:48:58 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so2968450fgg.23 for ; Mon, 12 May 2008 23:48:57 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=tc9hcmdsWKPOf8I6bWGrVGybQoTEzDw1ibCD9aDHbCI=; b=G1LtphPeGoevEI+RVNe8S1FLK/bCNedr4B408f+TlbtIqdzG6z/U7kmuiOAjW/5D4fa9oSl+qk7trJrnE7Goae2P/C1hoEjntSvDqGHvt8F+2XlCDioiLCOwh1n/8yCXpWD2o60M2Lhjm1aU+2oHlrhBAzW4CYaeWMK7F5t10zg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fqVCIw1egiVSiFQyySBHde7UAYdn6htP40LZYQ89ydSGXqm1CmJaZH0MFPoazQJLzFn4F1iHElXVOzdh+5CRhHSGKghQw4Xe520u6QdR/o2TzqMwesYTdLWV/Em3shX+hPd8APzg9yZ/rtEMbM+uJ1Ad/ILjMuMrEE04KbzIUAA= Received: by 10.86.28.2 with SMTP id b2mr15686493fgb.78.1210660939942; Mon, 12 May 2008 23:42:19 -0700 (PDT) Received: by 10.86.81.6 with HTTP; Mon, 12 May 2008 23:42:19 -0700 (PDT) Message-ID: Date: Tue, 13 May 2008 08:42:19 +0200 From: "Claus Guttesen" To: "Gauri Kanekar" Subject: Re: Installation Steps to migrate to Postgres 8.3.1 Cc: pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550805122240j7ed6a494hfc10a8b08dad073e@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7e4ba9550805122240j7ed6a494hfc10a8b08dad073e@mail.gmail.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: 200805/157 X-Sequence-Number: 30125 > We want to migrate from postgres 8.1.3 to postgres 8.3.1. > Can anybody list out the installation steps to be followed for migration. > Do we require to take care of something specially. Perform a pg_dump, do a restore and validate your sql-queries on a test-server. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare