I had been reading through through this: http://www.postgresql.org/about/
And That I saw this:
A company class database, PostgreSQL boasts sophisticated features for example ... time recovery
I want some light shed about this subject and it is features and good examples from it for action or share their very own performance encounters?
You might like to consult documentation.
I believe that you will need to read mostly part "24.4. Warm Standby Servers for top Availability" - but what's written there's according to information from "24.3. Continuous Archiving and Point-In-Time Recovery (PITR)" so you might like to see clearly first.
- pitr allows you need to do continuous backup with really low performance impact.
- this backup is incremental
- it may be restored to the given time (hence the title)
- using pitr you may also setup warm standby server