Can anyone advise me if either PostgreSQL 8.3 or 8.4 is ready for special case of production use? I'm considering using the windows version PostgreSQL in the following conditions: at least 10 years of up time (with periodic power failures <= 1 a year) single table with less-than 50 record inserts a day reporting at most once a month by a single connection no future patches applied no DBA for routine maintenance only CRON-like maintenance (windows scheduler) I have a project to integrate a solution to log daily production numbers for historical reporting. The daily production numbers are calculated values produced by a programmable logic controller (PLC). These values will be persisted to a data stored (I'm proposing Pg) on an industrial computer having a windows O/S. Here is the problem that concerns me, because the PLC and industrial computer will be located in a control panel in an industrial area no DBA will have access to provide routine maintenance to the database. Other than the occasional loss of power, does any one feel confident that the windows version of postgres as it is today can run without crashes for an up-time of at least 10 years? I my case, I used the windows version of PostgreSQL daily for 4 years. I've only experienced one crash with version 8.4.0. Since the update, I've yet to see any additional crashes. -- Regards, Richard Broersma Jr. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
