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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Mitchell Bösecke <mitchell(dot)bosecke(at)forcorp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Does "pg_ctl stop" wait for archiving to complete?
Date: 2014-11-07 06:09:14
Message-ID: CAECtzeX-YsAWovmn+LtoOW_bHFnmHynkr11yq3p9hJj2-Xx1kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 6 nov. 2014 21:59, "Mitchell Bösecke" <mitchell(dot)bosecke(at)forcorp(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2014-11-07 10:03:33 Re: Autocommit off in psql
Previous Message Payal Singh 2014-11-06 22:11:50 Re: Does "pg_ctl stop" wait for archiving to complete?