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

Does "pg_ctl stop" wait for archiving to complete?

From
Mitchell Bösecke
Date:
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?

In my case, I WANT the pg_ctl command to hang until all files are archived because immediately after I issue "pg_ctl stop" I want to be able to unmount the disk that the archived logs are being copied to.

Thanks for any information,

Mitchell

--
Mitchell Bosecke, B.Sc.
Software Developer

FORCORP
#101, 11710 Kingsway NW
Edmonton , AB, T5G 0X5

(o) 587.410.4067
(f) 780.453.3986

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

From
Payal Singh
Date:
pg_ctl always shuts down the database cleanly unless used in immediate mode . So as long as you use -m fast or -m smart (default), your database will remain consistent (no data loss) and startup without any issues later on.

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Thu, Nov 6, 2014 at 3:49 PM, Mitchell Bösecke <mitchell.bosecke@forcorp.com> wrote:
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?

In my case, I WANT the pg_ctl command to hang until all files are archived because immediately after I issue "pg_ctl stop" I want to be able to unmount the disk that the archived logs are being copied to.

Thanks for any information,

Mitchell

--
Mitchell Bosecke, B.Sc.
Software Developer

FORCORP
#101, 11710 Kingsway NW
Edmonton , AB, T5G 0X5


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

From
Guillaume Lelarge
Date:

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.

> In my case, I WANT the pg_ctl command to hang until all files are archived because immediately after I issue "pg_ctl stop" I want to be able to unmount the disk that the archived logs are being copied to.
>
> Thanks for any information,
>
> Mitchell
>
> --
> Mitchell Bosecke, B.Sc.
> Software Developer
>
> FORCORP
> #101, 11710 Kingsway NW
> Edmonton , AB, T5G 0X5
> www.forcorp.com
>
> (o) 587.410.4067
> (f) 780.453.3986

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

From
Bruce Momjian
Date:
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.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


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

From
Guillaume Lelarge
Date:
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.


--

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

From
Bruce Momjian
Date:
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. +