On 1 June 2013 15:45, Tom Lane wrote:
> Simon Riggs writes:
>> The way to resolve this is to have two functions:
>> pg_is_in_backup() - which covers both/all kinds of backup
>> pg_is_in_exclusive_backup() - which covers just the exclusive backup mode
>
> What will you do with pg_backup_start_t
On 2013-06-01 08:27:42 -0700, Joe Conway wrote:
> > Uh. Why would you do the lock(file) thingy *after* calling
> > pg_start_backup? You should do lock before calling start backup
> > and remove the lock after calling stop backup. In that case I don't
> > see where the race condition is?
>
> No, t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/01/2013 08:14 AM, Andres Freund wrote:
> On 2013-06-01 08:11:26 -0700, Joe Conway wrote:
>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1
>>
>> On 06/01/2013 02:43 AM, Christoph Moench-Tegeder wrote:
>>> ## Joe Conway (m...@joeconway.com):
>>>
On 2013-06-01 08:11:26 -0700, Joe Conway wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 06/01/2013 02:43 AM, Christoph Moench-Tegeder wrote:
> > ## Joe Conway (m...@joeconway.com):
> >
> >> However there is a period of time after pg_start_backup() is
> >> first executed to when i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/01/2013 02:43 AM, Christoph Moench-Tegeder wrote:
> ## Joe Conway (m...@joeconway.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 ye
Simon Riggs writes:
> The way to resolve this is to have two functions:
> pg_is_in_backup() - which covers both/all kinds of backup
> pg_is_in_exclusive_backup() - which covers just the exclusive backup mode
What will you do with pg_backup_start_time()?
regards, tom la
On 31 May 2013 21:06, Andres Freund wrote:
> On 2013-05-31 22:53:14 +0300, Heikki Linnakangas wrote:
>> On 31.05.2013 22:36, Andres Freund wrote:
>> >On 2013-05-31 22:29:45 +0300, Heikki Linnakangas wrote:
>> >>Note that pg_is_in_backup() just checks for presence of
>> >>$PGDATA/backup_label. Also
## Joe Conway (m...@joeconway.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 rese
On 2013-06-01 17:05:57 +0900, Michael Paquier wrote:
> On Sat, Jun 1, 2013 at 4:55 AM, Alvaro Herrera
> wrote:
>
> > Heikki Linnakangas wrote:
> >
> > > The manual says:
> > > >pg_is_in_backup()boolTrue if an on-line exclusive backup is
> > still in progress.
> > >
> > > So clearly that i
On Sat, Jun 1, 2013 at 4:55 AM, Alvaro Herrera wrote:
> Heikki Linnakangas wrote:
>
> > The manual says:
> > >pg_is_in_backup()boolTrue 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
On 2013-05-31 22:53:14 +0300, Heikki Linnakangas wrote:
> On 31.05.2013 22:36, Andres Freund wrote:
> >On 2013-05-31 22:29:45 +0300, Heikki Linnakangas wrote:
> >>Note that pg_is_in_backup() just checks for presence of
> >>$PGDATA/backup_label. Also note that pg_basebackup doesn't create
> >>backup
Heikki Linnakangas wrote:
> The manual says:
> >pg_is_in_backup()boolTrue 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 wha
On 31.05.2013 22:36, Andres Freund wrote:
On 2013-05-31 22:29:45 +0300, Heikki Linnakangas wrote:
Note that pg_is_in_backup() just checks for presence of
$PGDATA/backup_label. Also note that pg_basebackup doesn't create
backup_label in the server. It's included in the backup that's sent to the
c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/31/2013 12:36 PM, Andres Freund wrote:
> On 2013-05-31 22:29:45 +0300, Heikki Linnakangas wrote:
>> Note that pg_is_in_backup() just checks for presence of
>> $PGDATA/backup_label. Also note that pg_basebackup doesn't
>> create backup_label in t
On 2013-05-31 22:29:45 +0300, Heikki Linnakangas wrote:
> On 31.05.2013 21:41, Joe Conway wrote:
> >On 05/31/2013 10:46 AM, Heikki Linnakangas wrote:
> >>On 31.05.2013 20:38, Joe Conway wrote:
> >>>I can check for the presence of $PGDATA/backup_label in order to
> >>>detect a backup in progress (i.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/31/2013 12:29 PM, Heikki Linnakangas wrote:
> Note that pg_is_in_backup() just checks for presence of
> $PGDATA/backup_label. Also note that pg_basebackup doesn't create
> backup_label in the server. It's included in the backup that's sent
> to
On 31.05.2013 21:41, Joe Conway wrote:
On 05/31/2013 10:46 AM, Heikki Linnakangas wrote:
On 31.05.2013 20:38, 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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/31/2013 10:46 AM, Heikki Linnakangas wrote:
> On 31.05.2013 20:38, 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() h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/31/2013 10:42 AM, Andres Freund wrote:
> 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
On 31.05.2013 20:38, 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
On 31 May 2013 18:38, Joe Conway wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> 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 per
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
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 t
23 matches
Mail list logo
