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 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. Systems and Network Administrator Morrison Industries 1825 Monroe Ave NW. Grand Rapids, MI. 49505