Re: detecting binary backup in progress

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: detecting binary backup in progress
Date: 2013-06-01 08:21:08
Message-ID: 20130601082108.GF3955@alap2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2013-06-01 17:05:57 +0900, Michael Paquier wrote:
> On Sat, Jun 1, 2013 at 4:55 AM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>wrote:
>
> > Heikki Linnakangas wrote:
> >
> > > The manual says:
> > > >pg_is_in_backup() bool True if an on-line exclusive backup is
> > still in progress.
> > >
> > > So clearly that is intentional. That could use some rephrasing,
> > > though; a layman won't know what an "exclusive backup" is.
> >
> > Heck, I don't understand what it is either.
> >
> Same here. Does it mean taking a backup not with pg_basebackup but by
> executing yourself external operations between pg_start/stop_backup calls?

Basically yes. pg_start/stop_backup places the backup label into the data
directory itself so there can only be one of them at a time since it has
to have a fixed name. With the streaming protocol the backup label is
only added to the streamed data, so there can be multiple ones at the
same time.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2013-06-01 08:22:05 Combo xids
Previous Message Michael Paquier 2013-06-01 08:05:57 Re: detecting binary backup in progress