Greetings everyone. I would like to know what the correct position is on the use of Postgres with DJB's daemontools or other monitoring prgrams?
I tried to set it up the other day and was successful in getting it to start and log, and even refresh the config files, but I could not get it to shutdown. I have to assume (although possibly incorrectly) that because I was using Apache and PHP with persistent Postgres connections, that the problem I was seeing (via svstat, ps) was those connections refusing to shut down, primarily because I could see no facility to include the -m fast switch and option. So before I go tackling this any further, is monitoring Postgres with daemontools even a good idea? It sounds good but I have concerns how it would handle a computer shutdown. I'm also concerned that without a method to notify me, it could shutdown and restart a thousand times an hour and I would never know if there was an issue. I was also looking into monit. What is the best way to monitor the postmaster and notify or restart on problems? What solutions have other SysAdmin's incorporated successfully? ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
