Upgrading using streaming replication

From: Damien Churchill <damoxc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading using streaming replication
Date: 2011-03-11 11:58:01
Message-ID: AANLkTimU=z2w9to0NHEeAKS5ktAzkCCZCHBBDzOma0y2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

I have done quite a bit of searching but have been unable to find any
way to do this. I am quite keen to use PostgreSQL 9.0's streaming
replication to create a master/slave write/read setup. However I am
unsure of an upgrade procedure whilst using streaming replication that
doesn't yield any downtime (including being able to write). From what
I have read the WAL won't be compatible between 9.0 and 9.1 so it
won't be possible to take the slave off-line and upgrade it, promote
it to master and then upgrade the old master.

So I was wondering if anyone knows of a method that allows you to do
this. Sorry if this is an often asked question and I just haven't been
able to find the answer.

Regards,
Damien

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2011-03-11 12:02:18 Re: Upgrading using streaming replication
Previous Message Bruce Momjian 2011-03-11 10:35:55 Re: how can I get back superuser back?