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

From: Andreas Zeugswetter <andreas.zeugswetter_at_telecom.at>
Date: Fri, 17 Nov 2000 17:34:15 +0100
Message-ID: <3A155E07.5040907@telecom.at>

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 Received on Fri Nov 17 2000 - 10:34:15 CST