Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!

>>>>4. You can't backup PostgreSQL without taking the database offline, >>>>which definitely takes it out of the "enterprise ready" catagory. >>>This is untrue. You can't backup a portgres database if you have it >>>offline. Did you see the CAN'T (= can NOT). >>Well, I mean back it up by backing up the files (as PosgreSQL doesn't >>support a raw-device concept) with filesystem tools such as tar. I'm >>awareof "pg_dump" which backs up an "online" database but if a table is >>under active use I do not believe that pg_dump can produce a safe snap >>shop of a table, which REALLY limits it. Also locking a table during >>backup isn't acceptable in a 24/7 enviroment either. >I am aware of this, but almost all the backup system will change with >Posatgres 7.1. Then I very much look forward to see-ing 7.1 Their backup method has been neglected for some time. But I'm a "when I can see, touch, and smell it" kind of guy, the "future" is vapor-ware, open source or not. >What I'm trying to say is that YES, informix is a better engine then >Postgres, in lots of points of views. But I see much more progress in >PostgreSQL then in informix or oracle. I believe that it's because of >the nature of it been an Open Source database, having direct contact >between the developers and the users. I believe that is very importante! This certainly lends to it's ongoing improvement and success. I'm definitely a PostgreSQL booster, for applications to which it is appropriate, and I use it extensively myself, but it only tarnishes a products reputation when people over-state it's utility. >As far as my experience with informix, support really sucks. I have >sent lots of messages to the informix support with behave of the >Solaris 8 problem and had no responce at all (not even a: "contact >your SUN dealer"), which happen to be the same that happened with >the SUN support team. No answer at all. Communication is not Informix's strong suit and is always slow and frustrating (I'm no fan of their web site either). But the tech people I have talked too seem to be competent and a least put in a real effort to solving a problem. Systems and Network Administrator Morrison Industries 1825 Monroe Ave NW. Grand Rapids, MI. 49505