From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | Simon Crute <Simon(at)geordie(dot)demon(dot)co(dot)uk> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How robust is postgresql ? |
Date: | 2001-03-07 18:53:00 |
Message-ID: | Pine.LNX.4.30.0103071345410.15784-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 6 Mar 2001, Simon Crute wrote:
> We're writing an app in Perl and currently using Oracle as the backend
> database (via the perl DBI) but due to the costs when we put this live we're
> thinking of useing Postgresql.
Good choice! Version 7.1, now in beta and due out very soon, has a lot of
new stuff that is very smart and cool.
> However we need to know how crash resistant Posgresql is. Oracle has the
> "Archive log mode" which writes a log of everything that's casued the
> database to change. This allows you to recoved it properly in the event of a
> crash.
>
> Does Postgresql have anything simmilar ? I've read about Postgresql's "fsync
> mode". Does this guarantee that the data is written to the disk properly and
> that the in the even of a crash (such as power outage etc) the database will
> still be correct ?
7.1 has write-ahead logging (WAL), which does what you are looking for.
See http://www.postgresql.org/devel-corner/docs/admin/wal.html
The fsync mode also helps with data integiry, but it *really* slows down
the system, unfortunately.
> The other question is Backups. Is there anyway to take diferential backups ?
> I.E do a full dump periodically, and then make diferential backups from time
> to time (preferably to a differet box)
You can do a database dump and back up the SQL generated, or do a
filesystem backup. See
http://www.postgresql.org/devel-corner/docs/admin/backup.html for
information on the specifics.
-- Brett
http://www.chapelperilous.net/~bmccoy/
------------------------------------------------------------------------
You can't mend a wristwatch while falling from an airplane.
From | Date | Subject | |
---|---|---|---|
Next Message | Eric, Audet | 2001-03-07 18:54:10 | When is 7.1 going out |
Previous Message | will trillich | 2001-03-07 17:24:34 | explain -> how to optimize? |