Hi all, 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. 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 ? 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) Thanks. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
