Re: Does "pg_ctl stop" wait for archiving to complete? - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Does "pg_ctl stop" wait for archiving to complete?
Date
Msg-id 20141222233042.GA3520@momjian.us
Whole thread Raw
In response to Re: Does "pg_ctl stop" wait for archiving to complete?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
On Sun, Dec 21, 2014 at 11:14:21PM +0100, Guillaume Lelarge wrote:
> 2014-12-06 14:26 GMT+01:00 Bruce Momjian <bruce@momjian.us>:
>
>     On Fri, Nov  7, 2014 at 07:09:14AM +0100, Guillaume Lelarge wrote:
>     > 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.
>
>     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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Does "pg_ctl stop" wait for archiving to complete?
Next
From: Sandeep Gondhalekar
Date:
Subject: java.lang.ClassNotFo​undException: oracle.jdbc.driver.O​racleDriver