use wal archiving scheme from 8.1 on 9.0

Поиск
Список
Период
Сортировка
От zhong ming wu
Тема use wal archiving scheme from 8.1 on 9.0
Дата
Msg-id AANLkTi=Qdk4ZKA=kS_QPMWE-dqZfK4fBb1yOSjk4RjdR@mail.gmail.com
обсуждение исходный текст
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Sheng Hui
Дата:
Сообщение: A strange SQL grammar issue with postgreSql 8.4.4 & Hibernate 3.5
Следующее
От: Tom Lane
Дата:
Сообщение: Re: A strange SQL grammar issue with postgreSql 8.4.4 & Hibernate 3.5