Configuration in Pentaho to change from active postgres after Data base crashes to passive postgres

PostgreSQL Installation and Configuration on Single Node and Multi Node Clustering for Load Balancing, Database deployment, cluster control fail over.

Pgpool is a middleware that works between PostgreSQL servers and a PostgreSQL database client. Pgpool can manage multiple PostgreSQL servers.

Pganalyze is a monitoring system for PostgreSQL databases. It processes statistics data available from the built-in Postgres statistics views, as well as additional system level data like CPU and I/O performance metrics.

Steps for Installation of Postgresql in RHEL 7 with different data directory