From: Lewis Kapell <lkapell@setonhome.org>
To: pgsql-admin@postgresql.org
Subject: Migrating from 8.3 to 8.4 on the same server
Date: Wed, 14 Apr 2010 13:29:23 -0400
Message-ID: <4BC5FB73.9@setonhome.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lkapell@setonhome.org
Subject: Re: Migrating from 8.3 to 8.4 on the same server
In-Reply-To: <4BC5FB73.9@setonhome.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox