thanks, it looks exactly as I was searching for On Thu, Feb 16, 2012 at 23:05, Marti Raudsepp <ma...@juffo.org> wrote:
> On Thu, Feb 16, 2012 at 18:53, sodik <stanislav.miklik...@gmail.com> > 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 server from the database, > then you can create a custom procedure to check for this file and call > it via SQL. > > Regards, > Marti >