Re: [GENERAL] Check if backup is in progress

2012-02-17 Thread sodik
thanks, it looks exactly as I was searching for On Thu, Feb 16, 2012 at 23:05, Marti Raudsepp wrote: > On Thu, Feb 16, 2012 at 18:53, sodik > wrote: > > is there any way how to check that postgres 9.1 is currently in backup > > mode? > > You can check the existence of the "backup_label" file in

Re: [GENERAL] Check if backup is in progress

2012-02-16 Thread Marti Raudsepp
On Thu, Feb 16, 2012 at 18:53, sodik wrote: > is there any way how to check that postgres 9.1 is currently in backup > mode? You can check the existence of the "backup_label" file in your data directory. If it's there, then a backup is in progress. If your monitoring system is on a diferent serv

[GENERAL] Check if backup is in progress

2012-02-16 Thread sodik
Hi, is there any way how to check that postgres 9.1 is currently in backup mode? Imagine the situation that my DB is running and the backup is remotely started by # select pg_start_backup('backup', true); However the remote site crashed and can't stop the backup. Is there any way how to check i