Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 3 down vote accepted

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

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


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.