Re: Backup's from standby

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Backup's from standby
Дата
Msg-id CA+U5nM+20KrEmb+f71J6c1jN6oKg2iYO_b+ZjQhF489Zs74=Bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Backup's from standby  (senthilnathan <senthilnathan.t@gmail.com>)
Список pgsql-hackers
On Tue, Aug 16, 2011 at 7:34 AM, senthilnathan
<senthilnathan.t@gmail.com> wrote:
> Thanks for your reply.
>
> What will happen if you issue *checkpoint* at STANDBY. I presume that it
> will flush the data to the disk.

Yes. On the standby that is known as a restartpoint.

> Will there be any conflict with the master WAL.(like checkpoint location...)

No, there is no effect on the master. The restartpoint happens as a
background process on the standby, so replay will continue while we
restart.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Backup's from standby
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_stat_replication vs StandbyReplyMessage