| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Joe Conway <mail(at)joeconway(dot)com> |
| Cc: | "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: detecting binary backup in progress |
| Date: | 2013-05-31 17:42:13 |
| Message-ID: | 20130531174213.GF4606@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2013-05-31 10:38:56 -0700, Joe Conway wrote:
> I can check for the presence of $PGDATA/backup_label in order to detect
> a backup in progress (i.e. pg_start_backup() has been run and
> pg_stop_backup() has not yet been run).
>
> However there is a period of time after pg_start_backup() is first
> executed to when it completes, during which backup_label file does not
> exist yet, but the backup has essentially been started. Is there any
> way to detect this state?
9.3 has pg_is_in_backup() for that. I don't think there's a way to
detect it safely without C code before that.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2013-05-31 17:42:53 | Re: detecting binary backup in progress |
| Previous Message | Amit Langote | 2013-05-31 17:41:19 | Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries |