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

Posted in 2000

Andreas Zeugswetter — Fri, 17 Nov 2000 17:34:15 +0100 — source: Informix-list mailing list archive (1991-1998)

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. This is not true. pg_dump takes a consistent snapshot of your whole database. Andreas