Skip site navigation (1) Skip section navigation (2)

Re: Core team statement on replication in PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>, "Hannu Krosing" <hannu(at)krosing(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Core team statement on replication in PostgreSQL
Date: 2008-06-04 14:40:58
Message-ID: 24477.1212590458@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:
> Hmm, WAL version compatibility is an interesting question. Most minor 
> releases hasn't changed the WAL format, and it would be nice to allow 
> running different minor versions in the master and slave in those cases. 
> But it's certainly not unheard of to change the WAL format. Perhaps we 
> should introduce a WAL version number, similar to catalog version?

Yeah, perhaps.  In the past we've changed the WAL page ID field for
this; I'm not sure if that's enough or not.  It does seem like a good
idea to have a way to check that the slaves aren't trying to read a
WAL version they don't understand.  Also, it's possible that the WAL
format doesn't change across a major update, but you still couldn't
work with say an 8.4 master and an 8.3 slave, so maybe we need the
catalog version ID in there too.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-06-04 14:56:44
Subject: Re: Proposal: new function array_init
Previous:From: Andrew SullivanDate: 2008-06-04 14:36:23
Subject: Re: Core team statement on replication in PostgreSQL

pgsql-advocacy by date

Next:From: Hannu KrosingDate: 2008-06-04 15:27:04
Subject: Re: Core team statement on replication in PostgreSQL
Previous:From: Andrew SullivanDate: 2008-06-04 14:36:23
Subject: Re: Core team statement on replication in PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group