Reliability of Windows versions 8.3 or 8.4

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reliability of Windows versions 8.3 or 8.4
Date: 2010-05-12 15:45:15
Message-ID: AANLkTimnEiRrgVDh2PKBr5r9I8pb_ssY5KLsdntPyxqj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-05-12 15:45:22 Re: Shell script to Backup/Dump Database
Previous Message Guillaume Lelarge 2010-05-12 15:41:57 Re: can function arguments have the type tablename.columnname%TYPE?