From: Bruce Momjian <bruce@momjian.us>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Mitchell Bösecke <mitchell.bosecke@forcorp.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Does "pg_ctl stop" wait for archiving to complete?
Date: Mon, 22 Dec 2014 18:30:42 -0500
Message-ID: <20141222233042.GA3520@momjian.us> (raw)
In-Reply-To: <CAECtzeXjOhcZjdeg1NhAbTk8r+R5pfJwG5z-3Ux5Wwr+11KgRg@mail.gmail.com>
References: <CACT-PvJ28eTEfOUjxYVCK0ETVBmH895pP2D9WPSjBCdKN-dXsA@mail.gmail.com>
<CAECtzeX-YsAWovmn+LtoOW_bHFnmHynkr11yq3p9hJj2-Xx1kg@mail.gmail.com>
<20141206132632.GB1314@momjian.us>
<CAECtzeXjOhcZjdeg1NhAbTk8r+R5pfJwG5z-3Ux5Wwr+11KgRg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, guillaume@lelarge.info, mitchell.bosecke@forcorp.com
Subject: Re: Does "pg_ctl stop" wait for archiving to complete?
In-Reply-To: <20141222233042.GA3520@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox