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