Thanks for the answer, (and thanks to adb too)
>
> 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.
Loo
As of version 7.1 postgres uses write ahead logging which is what
you are looking for.
As for backups, currently your only option is full dumps of the entire
db or full dumps of individual tables.
Some folks are working around this by using replication to
a secondary server with rserv (in contr
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 l
