Re: Type of application that use PostgreSQL

Peter Childs wrote:
> On Fri, 3 Oct 2003, Ron Johnson wrote:
>
>
>>On Fri, 2003-10-03 at 04:26, Shridhar Daithankar wrote:
>>
>>>Peter Childs wrote:
>>
>>[snip]
>>
>>>Postgresql do have update logs in form of WAL. However it can not do PITR with
>>>log archiving if a node in cluster goes down for extended period. WAL does not
>>>handle these situations in current design. Precisely, PITR is the feature that
>>>implements this functonality.
> No it does not. WAL is Down-Date Logs not update logs. WAL will
> enable you to rewind to the beginning of all currently running
> transactions after a crash. Ie roll-back not roll-forward.

Right. But if WAL files from one host are dropped to WAL log dir. of another
host, it will play them provided they have identical structure. IIRC there are
some replication solution which works on this basis.
>>For those not in the know, PITR is Point In Time Recovery.
>>
>>And yes, that capability has been around for 20+ years on mainframes
>>and minicomputers, but they were/a`re funded a lot higher than the
>>PostgreSQL volunteers are!
> It was planned for 7.4 so when is it going to happern now it has
> missed 7.4?

7.5. Lots of things have missed 7.4 boat. PITR, nested transactions, native
windows ports etc. So hopefully 7.5 would have very small development cycle as
most of the features already have work going on.

Shridhar