Sunday, January 16, 2011

PostgreSQL 7.x archiving

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

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

    Andrew : I thought as much. Thanks for confirming.
    From Gnudiff

0 comments:

Post a Comment