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


It is an application where the data will be synchronized on the Server and PoS terminal. Thus the Master data GRN’s raised, vendor return, price change etc.


Try to remove unwanted un-used addons from “addons” folder. Tune postgres for better performance