Re: Monitoring hot standby replication for failure

Hi Mark,

You can used pglookout for PostgreSQL replication monitoring and failover
daemon. go with below link hopes this will help you.
https://github.com/aiven/pglookout

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Mon, Mar 25, 2019 at 11:21 PM Mark Steben <mark(dot)steben(at)drivedominion(dot)com>
wrote:

> 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>
>
>
>
>