Thread: Does "pg_ctl stop" wait for archiving to complete?
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. 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?
Mitchell
--
Mitchell Bosecke, B.Sc.
Software Developer
FORCORP
#101, 11710 Kingsway NW
Edmonton , AB, T5G 0X5
(o) 587.410.4067
(f) 780.453.3986
(f) 780.453.3986
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.
On Thu, Nov 6, 2014 at 3:49 PM, Mitchell Bösecke <mitchell.bosecke@forcorp.com> wrote:
Thanks for any information,Hi,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.
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?
Mitchell--Mitchell Bosecke, B.Sc.Software DeveloperFORCORP#101, 11710 Kingsway NWEdmonton , AB, T5G 0X5
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
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. +
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.
--
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. +