Re: detecting binary backup in progress

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
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-06-01 09:43:39
Message-ID: 20130601094339.GA2064@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

## Joe Conway (mail(at)joeconway(dot)com):

> 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?

When I did some research on the very same question just a few weeks
ago, I settled for external locks (lockfile, pg_advisory_lock(), ...,
depending on your exact situation) around the backup-taking code.

Regards,
Christoph

--
Spare Space

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Soroosh Sardari 2013-06-01 10:41:50 Which table stored in which file in PGDATA/base/[db-oid]
Previous Message javadi 2013-06-01 09:41:13 Question about storage subsystem of PotgreSQL