Monitoring hot standby replication for failure

From: Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Monitoring hot standby replication for failure
Date: 2019-03-25 17:50:42
Message-ID: CADyzmyxM9_10Wa8gu-HLbJZ9zR-w+1pwZ2yTaVqJH0AdDnD7Jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Good afternoon,

We are running postgres 9.4. We are outsourcing our databases to another
datacenter owned by a third party company. The methodology we are using to
move the database is hot standby log shipping replication. We will run
streaming replication for several days then, when the time comes to pull
the trigger and make the move, I will complete recovery, bring in a
'production' version of postgresql.conf, restart the database, and hand it
over to the apps.

We want to make sure that during the several days of replication we are
immediately notified if a problem arises - a missing log, a production
outage, etc. Is there a monitor or an 'in-the-box' procedure, or perhaps a
condition to check during hot standby or streaming replication to ensure
things are still running as planned, or if there is a problem?

Thanks for any insights.

--
*Mark Steben*
Database Administrator
@utoRevenue <http://www.autorevenue.com/> | Autobase
<http://www.autobase.net/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>

<http://autobasedigital.net/marketing/DD12_sig.jpg>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Frank Alberto Rodriguez Solana 2019-03-25 18:05:37 Re: Monitoring hot standby replication for failure
Previous Message Michael Banck 2019-03-24 11:26:53 Re: Is there a way to log only a particular user connection attempts in Postgres?