Re: detecting binary backup in progress - Mailing list pgsql-hackers

From Joe Conway
Subject Re: detecting binary backup in progress
Date
Msg-id 51A8FB86.4050004@joeconway.com
Whole thread Raw
In response to Re: detecting binary backup in progress  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
-----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 the client, but it's never written to disk in the server. So
> checking for backup_label manually or with pg_is_in_backup() will
> return false even if pg_basebackup is running.

Oh, that's really good to know.

So essentially there is no reliable way to know that pg_start_backup()
has been executed and pg_stop_backup() has not?

Joe

- -- 
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJRqPuGAAoJEDfy90M199hlAbIP/RkeOMMEc2aw0RjYbQKcGLRX
GJFU2MxymtnsbR6kqeijxgeug48NVu1Yx0yyw0rf2aS8pAN6v6Xd5aRIS9li+j/A
K6A16+2LxwvtTlyKFkdU/8NP4Uo/xAtG3qOBbfpYNT0YRwuKr8nA9UhWFOEG4+hQ
Kz27O5mwjTCzW6WSrre2HZxM4B3J1eWSKQrZ+WDUAmh6GEXAIkIXdDJJnjZqiZcJ
rNldh95lEEAPmqZXTq2tANYpIE7UHmRl7Vm0foNHbqsyy+fWGZtqWA4tK8mEVSrQ
QdPEa8CjzOAL9gL/bLN3Ti2UimLexKcG6jn9BaUiCNLj5G50tRSiUgH+ur1vSgyv
vQYmvi2E3W+L0FABzAuNcsEY1lb2V+JEBQua64m82tOyDvXPpULKw3Bi7PKcxkci
M8Si1knYUnWdaeUV3c1ZVbVmtTGtanSF1TiLJH/S7tLb49eoTN3pF3EpIGSXNqcc
4H2Ixemdtu/PZ0FGT9+sKGcIWo+Bp37pdnXXWiGc/kZMML2I+5BK+/Pd6Tm3nJFH
MDVI7NrPUqCtSHbrDZ/Uv9fKLulaq0kHznyNg9tW0XBwHNpM9RJcbw9Vq88UgDDW
mlaTCvR6G7GM72R1+czM/ek3Oy7v/sPZQmeJrVk0OdPqCe31myyBYP2XRWMW2cW2
2S7SSN2LnQD1YF9VrrYt
=c9gP
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: detecting binary backup in progress
Next
From: Andres Freund
Date:
Subject: Re: detecting binary backup in progress