Re: PITR (was Re: [GENERAL] Type of application that use PostgreSQL)

2003-10-06 Thread Shridhar Daithankar
Ron Johnson wrote: All that we basically need for PITR is to provide management code that lets old WAL segments get archived off to tape (or wherever) rather than deleted, plus some kind of control that lets the roll-forward process be stopped at the desired point-in-time rather than necessarily ru

Re: [GENERAL] Type of application that use PostgreSQL

2003-10-03 Thread Tom Lane
Shridhar Daithankar <[EMAIL PROTECTED]> writes: > Peter Childs wrote: >>> Postgresql do have update logs in form of WAL. >> 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-bac

Re: [GENERAL] Type of application that use PostgreSQL

2003-10-02 Thread Richard Huxton
On Thursday 02 October 2003 09:10, My Internet wrote: > Hello, > > I am in the process to define if our product can use PostgreSQL. > > Do you know what type of application use PostgreSQL, and also what is the > size of the database for these projects? Everything from small-business apps (which I

[GENERAL] Type of application that use PostgreSQL

2003-10-02 Thread My Internet
Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Our application has a table with more than 30 rows. There are complexe query with many joins. And we mu