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

I'm looking for info about the synching and I don't see any. Is there a
more specific URL and is there a time frame for this. Also, has
segmentation been discussed?

-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Peter Eisentraut
Sent: Tuesday, October 10, 2000 1:08 PM
To: Marc SCHAEFER
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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/