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

On Sun, Dec 21, 2014 at 11:14:21PM +0100, Guillaume Lelarge wrote:
> 2014-12-06 14:26 GMT+01:00 Bruce Momjian <bruce(at)momjian(dot)us>:
>
> On Fri, Nov  7, 2014 at 07:09:14AM +0100, Guillaume Lelarge wrote:
> > 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.
>
> 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.

No problem. Originally we didn't archive the last WAL file on shutdown
but Simon fixed that a few years ago.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +