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

On Mi' 15 Nov 2000 12:10, Adam Tauno Williams wrote: > >>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 aware > of "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. 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! 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. Conclusion: Informix support is not as good as they say it is, but the engine is much better then others in some points. P.D.: As you can see, my focus is on the future, not the present. Saludos... :-) -- "And I'm happy, because you make me feel good, about me." - Melvin Udall ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------