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

Поиск
Список
Период
Сортировка
От Payal Singh
Тема Re: Does "pg_ctl stop" wait for archiving to complete?
Дата
Msg-id CANUg7LBTBYm5D6o1YFNa=GpRUVAfHfpFfPFNcSD_Pza6SkE9vA@mail.gmail.com
обсуждение исходный текст
Ответ на Does "pg_ctl stop" wait for archiving to complete?  (Mitchell Bösecke <mitchell.bosecke@forcorp.com>)
Список pgsql-admin
Дерево обсуждения
pg_ctl always shuts down the database cleanly unless used in immediate mode . So as long as you use -m fast or -m smart (default), your database will remain consistent (no data loss) and startup without any issues later on.

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Thu, Nov 6, 2014 at 3:49 PM, Mitchell Bösecke <mitchell.bosecke@forcorp.com> wrote:
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?

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


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