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
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? |