The following bug has been logged on the website:
Bug reference: 15963
Logged by: Sreekantan K
Email address: kris.sreekantan@gmail.com
PostgreSQL version: 9.5.2
Operating system: Linux
Description:
KSEBL has a billing application KSEBLTNET catering service to over 1.25
crores of consumers. We are using PostgreSQL 9.5.2 on x86_64-pc-linux-gnu,
compiled as DB and Linux as OS. The scripting language is PHP 5. DB size
is 4.6TB. Inorder to overcome performance issue we have started Archiving
process. For the last 2 years, DB connection fails at frequent intervals.
In the initial stages connection failures occured at 1PM. After some
periods of time it shifted to 12 noon. Now the problem is noticed at 11PM.
It hinders access to the system and the activities becomes stand still at
particular times as reported above. So kindly help us to solve the issue.