Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm trying to get PostgreSQL 7.4 setup to use PITR mode (as described here). It appears that the "archive_mode" option isn't recognised. Can anyone shed light on when this first appeared in PostgreSQL? I don't want to upgrade to a newer version unless I absolutely have to.

(For what it's worth, I was planning on using this to replicate PostgreSQL database updates across the wire to a warm standby database.)

share|improve this question

1 Answer 1

up vote 3 down vote accepted

PITR was introduced in 8.0, as seen in feature list:

http://www.postgresql.org/docs/8.4/static/release-8-0.html

Point-In-Time Recovery

In previous releases there was no way to recover from disk drive failure

except to restore from a previous backup or use a standby replication server. Point-in-time recovery allows continuous backup of the server. You can recover either to the point of failure or to some transaction in the past.

share|improve this answer
    
I thought as much. Thanks for confirming. –  Andrew Sep 9 '09 at 6:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.