On 20/06/17, Steve Clark (steve.clark@xxxxxxxxxxxxx) wrote: > > 4) Equipment table keyed to location. > We already have a monitoring system in place that has been in operation circa 2003. Just recently we have > added a new class of customer whose operation is not 24/7. > > I envision the schedule could be fairly complicated > including WE and holidays, plus the enduser might shut down for lunch etc. I am looking for more on how to organize the > schedule, EG a standard weekly schedule then exceptions for holidays etc, or a separate individual schedule for > each week, also need to consider how easy it is to maintain the schedule, etc. Assuming you have the ability to disable alerts for a client/location/group/machine for a period of time, you could use pg_cron schedules https://github.com/citusdata/pg_cron to enable and disable this ability on a scheduled basis. With some sort of front-end it would be trivial for the customer to make their own schedules. Rory -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
