Home / server / Questions / 63607
Accepted
Andrew
Asked: 2009-09-09 21:17:43 +0800 CST

PostgreSQL 7.x archiving

  • 772

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.)

postgresql

1 Answers

  1. Best Answer

    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.

    • 3