Postgres Pro
Downloads
Home   >   mailing lists

Thread: WAL files, warm spares and minor versions

WAL files, warm spares and minor versions

From
"Michael Nolan"
Date:
Can WAL files be used to create/update a warm standby on a different minor version of PostgreSQL (eg, using files from a server running  8.2.3 on an 8.2.4 server, or vice-versa?)

I suspect this is a FAQ, but I didn't see it in the docs on WALs and PITR (section 23.3)
--
Mike Nolan

Re: WAL files, warm spares and minor versions

From
Alan Hodgson
Date:
On Tuesday 24 April 2007 10:57, "Michael Nolan" <htfoot@gmail.com> wrote:
> Can WAL files be used to create/update a warm standby on a different
> minor version of PostgreSQL (eg, using files from a server running  8.2.3
> on an 8.2.4 server, or vice-versa?)
>
> I suspect this is a FAQ, but I didn't see it in the docs on WALs and PITR

I think it would just be assumed that it would not work.  Even different
system architectures with the same software versions won't work.

--
No long, complicated contracts. No actuarial tables to pore over.  Social
Security operates on a very simple principle: the politicians take your
money from you and squander it.

Re: WAL files, warm spares and minor versions

From
"Simon Riggs"
Date:
On Tue, 2007-04-24 at 12:57 -0500, Michael Nolan wrote:
> Can WAL files be used to create/update a warm standby on a different
> minor version of PostgreSQL (eg, using files from a server running
> 8.2.3 on an 8.2.4 server, or vice-versa?)
>
> I suspect this is a FAQ, but I didn't see it in the docs on WALs and
> PITR (section 23.3)

The docs for Warm Standby are in 23.4

"It is the policy of the PostgreSQL Global Development Group not to make
changes to disk formats during minor release upgrades, so it is likely
that running different minor release levels on primary and standby
servers will work successfully. However, no formal support for that is
offered and you are advised to keep primary and standby servers at the
same release level as much as possible. When updating to a new minor
release, the safest policy is to update the standby servers first — a
new minor release is more likely to be able to read WAL files from a
previous minor release than vice versa."

http://developer.postgresql.org/pgdocs/postgres/warm-standby.html

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com