Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database

2017-05-25 Thread Scott Whitney
Personally I push those off to my network monitor. Nagios in my case. I find a single integrated alert and escalation framework is better than individual tools, but that's just me. If you're using Nagios, let me know, and I can pop you several stub scripts to help. On May 25, 2017 2:50 PM, Rav

Re: [PERFORM] [ADMIN] could not create shared memory segment: Invalid argument

2015-07-13 Thread Scott Whitney
What is your kernel SHMMAX? Usually somewhere under /etc/sysconfig. Depends on your distro. This is telling you that your kernel does not have sufficient resources. Original message From: Ryan King - NOAA Affiliate Date: 07/13/2015 7:10 PM (GMT-06:00) To: pgsql-gene...@postgre

Re: [PERFORM] [ADMIN] Setting a default format for timestamp

2014-07-31 Thread Scott Whitney
_Where_ do you want that default format? Are you asking about a field? psql output? The O/S? What you're asking might be as simple as "datestyle," if you're just talking the output mask: http://www.postgresql.org/docs/9.1/static/runtime-config-client.html DateStyle ( string ) Sets the di