Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2016

    Unanswered: Unix Postgres 9.5. using pg_basebackup and WAL files. Can't get a PITR recovery

    I can't cut and paste my issues, so I will explain as best I can.

    I have all the settings that I can find, wal_level, archive_command,
    restore_command, directories defined, logs defined. My WAL files are stored off in
    another area with gzip in the archive_command. The restore_command also uses gunzip. Those work fine.
    (pg_xresetlog seems to work OK too)

    I can restore from a pg_basebackup, but if I define PITR in recovery.conf along with the
    tar'd pg_basebackup in place, I can't get to that point in time.

    Does it matter if I use hot_standby or archive? hot_standby should include archive functionality and then some.

    I am running on a port other than 5432 for this particular db instance. I have more than 1 postgres version running.
    One of my next experiments will be to run on the 5432 default.
    The only PG var I define is $PGDATA. I use full paths at this point.

    I've run through the examples in the documentation several times, but it seems that the WAL files just
    won't get picked up by the defined date/time in recovery.conf.

    This is all in experiment mode for now, so there is no urgency.
    But I have almost exhausted all testing permutations and combinations.

    There is a line in one of the manuals about the WAL logs not being able to do PITR.

    Does anyone have an idea?
    Last edited by flutterby; 07-14-16 at 18:26. Reason: Unix, not Uni

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts