Hi, On Mon, Feb 2, 2015 at 11:07 AM, <christian.echerer@xxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
