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

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 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 can get 1

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: 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

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: [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 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 > > th

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 Graf 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,

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 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 understand FLAT IS

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 failur

[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