Warm-standby in 8.2

From: "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Warm-standby in 8.2
Date: 2008-06-19 23:31:16
Message-ID: C84662912D280D4AB5C50100A100F0C503715DDA@ct11exm61.ds.mot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We have created a postgres database with a warm-standby in postgres 8.2
following the document on the archive by Charles Duffy. The standby
database is in continuous recovery mode and archived logs are synced to
the standby from primary, every 10 minutes. The primary and the standby
database are running fine but we need to monitor the standby database to
check that it is up, it is getting synced every 10 minutes, and that it
is not out of sync with primary database. What would be the best way to
make these checks or what processes to check to make sure that the
archived logs from primary database are continuously getting applied on
the standby database.

There must be other people using this set up so just need advice on how
people are monitoring the standby database. Any suggestions or help will
be highly appreciated.

Thanks
Paramjeet Bhella

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2008-06-19 23:51:17 Re: Warm-standby in 8.2
Previous Message Peter Kovacs 2008-06-19 21:05:13 Re: Readline support in psql -- worked earlier for me