[GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Richard Broersma
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

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Justin Graf
On 5/12/2010 11:45 AM, Richard Broersma wrote: 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

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Richard Broersma
On Wed, May 12, 2010 at 9:18 AM, Justin Graf jus...@magwerks.com wrote: I would do a plain text file something like XML.  Given this is for industrial use 10 years is a good number for warranty and support, but this stuff will hang around years later, think 20 to 30 years.  How many people

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Justin Graf
On 5/12/2010 12:33 PM, Richard Broersma wrote: On Wed, May 12, 2010 at 9:18 AM, Justin Grafjus...@magwerks.com wrote: I would do a plain text file something like XML. Given this is for industrial use 10 years is a good number for warranty and support, but this stuff will hang around

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread dennis jenkins
On Wed, May 12, 2010 at 11:33 AM, Richard Broersma richard.broer...@gmail.com wrote: On Wed, May 12, 2010 at 9:18 AM, Justin Graf jus...@magwerks.com wrote: I would do a plain text file something like XML. Given this is for industrial use 10 years is a good number for warranty and

SQLite (was: RE: [GENERAL] Reliability of Windows versions 8.3 or 8.4)

2010-05-12 Thread Rob Richardson
I use both PostgreSQL and SQLite in my job. I have mixed feelings about SQLite. If you play by its rules, it works very well, but I think you have to understand its rules well. If you do not set up your indexes correctly and do not use transactions correctly, performance can be horrible, but if

Re: SQLite (was: RE: [GENERAL] Reliability of Windows versions 8.3 or 8.4)

2010-05-12 Thread Joshua D. Drake
On Wed, 2010-05-12 at 13:45 -0400, Rob Richardson wrote: I use both PostgreSQL and SQLite in my job. I have mixed feelings about SQLite. If you play by its rules, it works very well, but I think you have to understand its rules well. If you do not set up your indexes correctly and do not

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Thomas Kellerer
Richard Broersma wrote on 12.05.2010 17:45: 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) I don't think you can get 10 years of up time on a Windows Server. Most of the security patches

Re: [GENERAL] Reliability of Windows versions 8.3 or 8.4

2010-05-12 Thread Richard Broersma
On Wed, May 12, 2010 at 10:55 AM, Thomas Kellerer spam_ea...@gmx.net wrote: Richard Broersma wrote on 12.05.2010 17:45: 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) I don't think you

Crash when connected as console (was: RE: [GENERAL] Reliability of Windows versions 8.3 or 8.4)

2010-05-12 Thread Rob Richardson
To yank this thread in yet another direction: The question of 8.3 vs 8.4 brings up a very irritating issue we have with one client. Originally, we had installed PostgreSQL 8.3 on his system. There is a program we occasionally have to use that requires us to use mstsc /console to connect to his