Hi,
On Mon, Feb 2, 2015 at 11:07 AM, <christian.echerer@manroland-web.com> wrote:
>
> Short test description (Postgres-Version 9.3.4)
> --------------------------------------
> - Do a recovering on the Master (new timeline is created)
> - Execute pg_upgrade on the Master (timeline informations are missing)
> - Try to setup a new streaming client on the master
> - Error occurs: ... : could not receive timeline history file from the primary server: ERROR: could not open file
"pg_xlog/00000002.history":No such file or directory
>
> A longer description can be found in the mail from 11.10.2014.
>
> How do I get streaming replication working again?
>
> My current workaround is to restore the master with the help of pg_restore, after updating the database server
version.It takes quite a long time, however, and is therefore a problem.
The path to reproduce the problem is quite simple:
- setup the master and the replica setup, and promote the replica,
creating a new timeline (timeline 2 by default)
- pg_upgrade the promoted replica. This would create a new cluster
with the same timeline, but without the history file.
- create the streaming-only replica. The streaming replication will
never start, since the timeline file is not there. The error messages
are:
ERROR: could not open file "pg_xlog/00000002.history": No such file
or directory
FATAL: could not receive timeline history file from the primary
server: ERROR: could not open file "pg_xlog/00000002.history": No
such file or directory
Note that this problem does not occur for the streaming-only replica
of the newly created cluster (with a timeline 1), even when there is
no timeline history file in the original datadir.
--
Regards,
Alexey Klyukin