Why does replication need the old history file?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Why does replication need the old history file?
Date: 2015-06-11 19:56:14
Message-ID: 5579E7DE.6020109@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

Sequence of events:

1. PITR backup of server on timeline 2.

2. Restored the backup to a new server, new-master.

3. Restored the backup to another new server, new-replica.

4. Started and promoted new-master (now on Timeline 3).

5. Started new-replica, connecting over streaming to new-master.

6. Get error message:

2015-06-11 12:24:14.503 PDT,,,7465,,5579e05e.1d29,1,,2015-06-11 12:24:14
PDT,,0,LOG,00000,"fetching timeline history file for timeline 2 from
primary server",,,,,,,,,""
2015-06-11 12:24:14.503 PDT,,,7465,,5579e05e.1d29,2,,2015-06-11 12:24:14
PDT,,0,FATAL,XX000,"could not receive timeline history file from the
primary server: ERROR: could not open file
""pg_xlog/00000002.history"": No such file or directory

Questions:

A. Why does the replica need 00000002.history? Shouldn't it only need
00000003.history?

B. Did something change in this regard in 9.3.6, 9.3.7 or 9.3.8? It was
working in our previous setup, on 9.3.5, although that could have just
been that the history file hadn't been removed from the backups yet.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shay Rojansky 2015-06-11 20:12:37 Re: Entities created in one query not available in another in extended protocol
Previous Message Alvaro Herrera 2015-06-11 19:22:48 Re: The purpose of the core team