Re: Some advanced database features, are they present in PostgreSQL - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Some advanced database features, are they present in PostgreSQL
Date
Msg-id Pine.LNX.4.21.0010101905160.759-100000@peter.localdomain
Whole thread Raw
In response to Some advanced database features, are they present in PostgreSQL  (Marc SCHAEFER <schaefer@alphanet.ch>)
Responses Re: Some advanced database features, are they present in PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Some advanced database features, are they present in PostgreSQL  (Marc SCHAEFER <schaefer@alphanet.ch>)
RE: Some advanced database features, are they present in PostgreSQL  ("Rob Hutton" <rhutton@istmanagement.com>)
List pgsql-general
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@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] My new job
Next
From: Peter Eisentraut
Date:
Subject: Re: Installation problem