PostgreSQL problems
From GridPP Wiki
Session opened/closed errors
Looking /var/log/messages
Aug 21 12:45:01 srm su(pam_unix)[18006]: session opened for user postgres by (uid=0) Aug 21 12:45:01 srm su(pam_unix)[18009]: session opened for user postgres by (uid=0) Aug 21 12:45:01 srm su(pam_unix)[18011]: session opened for user postgres by (uid=0) Aug 21 12:45:01 srm su(pam_unix)[18009]: session closed for user postgres Aug 21 12:45:02 srm su(pam_unix)[18006]: session closed for user postgres Aug 21 12:45:02 srm su(pam_unix)[18011]: session closed for user postgres
These messages appear whenever a connection to the database is opened and then closed, obviously. I initially thought there was a problem due to the number of these messages in the log file. However, I then found a cron job that I had forgotten about which was regularly querying the database for information.