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

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Does "pg_ctl stop" wait for archiving to complete?
Дата
Msg-id CAECtzeX-YsAWovmn+LtoOW_bHFnmHynkr11yq3p9hJj2-Xx1kg@mail.gmail.com
обсуждение исходный текст
Ответ на Does "pg_ctl stop" wait for archiving to complete?  (Mitchell Bösecke <mitchell.bosecke@forcorp.com>)
Ответы Re: Does "pg_ctl stop" wait for archiving to complete?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-admin

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.

> In my case, I WANT the pg_ctl command to hang until all files are archived because immediately after I issue "pg_ctl stop" I want to be able to unmount the disk that the archived logs are being copied to.
>
> Thanks for any information,
>
> Mitchell
>
> --
> Mitchell Bosecke, B.Sc.
> Software Developer
>
> FORCORP
> #101, 11710 Kingsway NW
> Edmonton , AB, T5G 0X5
> www.forcorp.com
>
> (o) 587.410.4067
> (f) 780.453.3986

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

Предыдущее
От: Payal Singh
Дата:
Сообщение: Re: Does "pg_ctl stop" wait for archiving to complete?
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Autocommit off in psql