Message-ID: <4BC5FB73.9@setonhome.org>
Date: Wed, 14 Apr 2010 13:29:23 -0400
From: Lewis Kapell <lkapell@setonhome.org>
Organization: Seton Home Study School
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Migrating from 8.3 to 8.4 on the same server
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

In the documentation under the heading "Migration Between Releases" we 
read:

<<It is also possible to use replication methods, such as Slony, to 
create a slave server with the updated version of PostgreSQL. The slave 
can be on the same computer or a different computer. [...] Such a 
switch-over results in only several seconds of downtime for an upgrade. >>

In the section "Warm Standby Servers for High Availability" it says:

<< For testing purposes, it is possible to run both primary and standby 
servers on the same system. >>

Although this section does not use the term Point-In-Time Recovery, I 
understand this is what it refers to.  Could the WAL/PITR method then be 
used to upgrade from 8.3 to 8.4 on the same server and avoid having the 
significant downtime of dump/restore?

If so, I understand the two servers would have to run on different 
ports.  Are there any other issues/traps to be aware of?

-- 

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School