Find cpanel users with postgresql databases
Find out the users who are using postgresql databases. Also find out the number of postgresql databases used by each users.
In cpanel the number of postgresql database’s used by each user is recorded in file
“/var/cpanel/datastore/username/postgres-db-count”. The following code snippet can used to find out users who is having postgresql databases and the number of database’s each one hold,
Output will be in the format(username:number of postgres databases) pasted below:
Other files that might be of interest 🙂