How to enable PITR on all POSTGRES server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ntech
    New Member
    • Jul 2007
    • 13

    How to enable PITR on all POSTGRES server

    Hello,
    While Performing the Online Recovery By PITR, We had a Problem as we didnt Understand the proper Way of Enabling PITR on all POSTGRES Server .
    again , when

    psql -c "select pg_start_backup ('pgpool-recovery')" postgres
    is executed, the following msg appeared.
    =============== ====
    WAL archive is not active
    archive command must be defined before onlime backups can be made
    =============== ==
    so , how can we proceed further , a help is needed !!!
    with regards
    Ntech
  • zermok
    New Member
    • Jul 2009
    • 1

    #2
    in postgresql.conf

    archive_mode = on # for pgpoolII
    archive_command = 'date >&2 && echo did dummy archiving for %f >&2 ' # for pgpoolII

    Comment

    Working...