Re: Some advanced database features, are they present in PostgreSQL

Marc SCHAEFER writes:

> - log all transactions to a special log file, that can be used for
> backup purposes:

Will be in 7.1.

> - hard transactions: cutting the power to a PostgreSQL server
> may cause data loss and/or data corruption. Some databases use
> sophisticated techniques to ensure serialization of operation
> through journaling, redoing some of the transactions at
> bootup time if required.

This is really the same as above in implementation. So same answer.

> - the ability to synchronize two database servers, with only the
> changes being exchanged, live. Or the ability to have many
> servers in a load-balancing or data scattering pool.

Something like this has recently been announced as add-on from PostgreSQL,
Inc. (www.pgsql.com) Haven't seen it used, though.

> - ability to have databases bigger than the host's maximum file size

That has been available for quite a while.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/