Re: Does "pg_ctl stop" wait for archiving to complete?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Does "pg_ctl stop" wait for archiving to complete?
Дата
Msg-id CAECtzeXjOhcZjdeg1NhAbTk8r+R5pfJwG5z-3Ux5Wwr+11KgRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Does "pg_ctl stop" wait for archiving to complete?  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Does "pg_ctl stop" wait for archiving to complete?
Список pgsql-admin
2014-12-06 14:26 GMT+01:00 Bruce Momjian <bruce@momjian.us>:
On Fri, Nov  7, 2014 at 07:09:14AM +0100, Guillaume Lelarge wrote:
> Le 6 nov. 2014 21:59, "Mitchell Bösecke" <mitchell.bosecke@forcorp.com> a écrit
> :
> >
> > Hi,
> >
> > My understanding is that when postgresql is shutdown it triggers a checkpoint
> which triggers the archiving of completed tx logs. Will the "pg_ctl stop"
> command wait for archiving to complete or is the act of archiving completely
> asynchronous from the shutdown process?
> >
>
> Nope, it doesn't wait for archiving.

Uh, are you sure about that?  I thought we did wait during shutdown
unless -W was used in pg_ctl stop.


Sorry for the very very late reply. I just checked, and you're definitely right. In fast mode, we wait for the WAL to be archived, unless -W was used.

Sorry about this, and thanks for fixing my mistake.


--

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

Предыдущее
От: Harshad Adalkonda
Дата:
Сообщение: Re: Logfile purge
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Does "pg_ctl stop" wait for archiving to complete?