From: | zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | use wal archiving scheme from 8.1 on 9.0 |
Date: | 2010-11-03 02:21:46 |
Message-ID: | AANLkTi=Qdk4ZKA=kS_QPMWE-dqZfK4fBb1yOSjk4RjdR@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello List
I have a nicely working system of maintaining a cold standby of master
8.1.11 server. System consists of a set of scripts to do a base
backup to standby and scheme to send wal files and restoring the cold
standby should the master server break down
I have another totally separate postgresql server 8.4.4 that stands
alone (without any slave standby server). I wish to upgrade this
8.4.4 server to 9.0.1 and at the same time build a hot standby server
for read-only queries. My question is can I essentially steal the
scripts and schemes from 8.1.11 to set up this 9.0.1 master/slave
system? Then set up a section for hot standby in the slave?
Thanks in advance
mr.wu
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-11-03 03:11:36 | Re: A strange SQL grammar issue with postgreSql 8.4.4 & Hibernate 3.5 |
Previous Message | Sheng Hui | 2010-11-03 02:12:29 | A strange SQL grammar issue with postgreSql 8.4.4 & Hibernate 3.5 |