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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Mitchell Bösecke <mitchell(dot)bosecke(at)forcorp(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Does "pg_ctl stop" wait for archiving to complete?
Date: 2014-12-21 22:14:21
Message-ID: CAECtzeXjOhcZjdeg1NhAbTk8r+R5pfJwG5z-3Ux5Wwr+11KgRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2014-12-22 23:30:42 Re: Does "pg_ctl stop" wait for archiving to complete?
Previous Message Harshad Adalkonda 2014-12-18 13:04:45 Re: Logfile purge