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

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

 



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@xxxxxxxxxxx> 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



[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