Re: pg_stop_backup does not complete - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: pg_stop_backup does not complete
Date
Msg-id 3f0b79eb1002231651j18022429qdb75b0b771c8184e@mail.gmail.com
Whole thread Raw
In response to Re: pg_stop_backup does not complete  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Feb 24, 2010 at 4:49 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Maybe.  But for sure, if it doesn't, and instead tells the user to
> issue pg_stop_backup(), then pg_stop_backup() had better WORK when the
> user tries to execute it.  I gather that the problem is that it has to
> finish all that outstanding archiving before shutting down, in which
> case Kevin's suggestion of having a command to abort the backup seems
> reasonable.  I might call it pg_abort_backup() rather than
> pg_fail_backup(), but...

Or how about adding new boolean parameter of pg_stop_backup() that
specifies whether WAL archiving needs to be waited?
   pg_stop_backup([wait boolean])

This parameter is optional. If true (default), it waits for archiving.

In warm-standby and SR, we don't need to wait for archiving before starting
the standby from the base backup. So pg_stop_backup(false) would be
useful for speedup of setup of log-shipping.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Pika buildfarm member failure on pgcrypto/test sha2
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_stop_backup does not complete