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

Home -> Community -> Usenet -> c.d.o.tools -> Re: World's No.1 SQL server!! PostgreSQL defeated Oracle, MS SQLserver, DB2, Sybase, Interbase....!!!!

From: Adam Tauno Williams <adam_at_morrison-ind.com>
Date: Wed, 15 Nov 2000 10:10:40 -0500 (EST)
Message-ID: <8uueie$cru$1@news.xmission.com>

>>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 Received on Wed Nov 15 2000 - 09:10:40 CST