PostgreSQL problems

From GridPP Wiki
Jump to: navigation, search

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.