Re: streaming replication question

Поиск
Список
Период
Сортировка
От Roberto Scattini
Тема Re: streaming replication question
Дата
Msg-id CAApYZY9yo9h55t5pfCYGzxwy_gxkRkEOHE7XTSXiy1y=Khab+w@mail.gmail.com
обсуждение исходный текст
Ответ на streaming replication question  (Roberto Scattini <roberto.scattini@gmail.com>)
Ответы Re: streaming replication question
Список pgsql-general



On Thu, Mar 21, 2013 at 3:32 PM, Roberto Scattini <roberto.scattini@gmail.com> wrote:
hi list,

i'm installing a streaming replication master-slave setup in ubuntu 12.04 LTS, with postgresql 9.1

the tutorials and the documentation are a very good start point, but i have one question related to some fine grained configurations.

it is said that i should stop the master db in order to make de starting backup, OR run pg_start_backup and keep the archive files for the slave to catch up. if i dont do this, maybe the slave stays far behind the master and the wal_segments arent enough to start the replication. 
if I understand this right, i can "combine" the old "warm standby" configs of archive_command in the master and restore command in the slave to ensure that the slave will have the necessary info to start the replication.


i mean, i can have both configurations enabled?


no, i think my setup, with this config, is just doing warm standby. but the streaming replication was working before adding archive_command to master and restore_command to slave.

i used the info from this site:

--
Roberto Scattini

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

Предыдущее
От: Roberto Scattini
Дата:
Сообщение: streaming replication question
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Bad plan on a huge table query