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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Dec 21, 2014 at 11:14:21PM +0100, Guillaume Lelarge wrote:
> 2014-12-06 14:26 GMT+01:00 Bruce Momjian <bruce@xxxxxxxxxx>:
> 
>     On Fri, Nov  7, 2014 at 07:09:14AM +0100, Guillaume Lelarge wrote:
>     > Le 6 nov. 2014 21:59, "Mitchell Bösecke" <mitchell.bosecke@xxxxxxxxxxx> 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@xxxxxxxxxx>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux