From: | Alexey Klyukin <alexk(at)hintbits(dot)com> |
---|---|
To: | christian(dot)echerer(at)manroland-web(dot)com, avandras(at)gmail(dot)com |
Cc: | bruce(at)momjian(dot)us, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Missing timeline history file after execution of pg_upgrade |
Date: | 2015-02-03 21:41:04 |
Message-ID: | CAAS3tyLcMjUDfjrqo3+dy257EjBAXkU_08z+GoxswCN-fzq74w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
On Mon, Feb 2, 2015 at 11:07 AM, <christian(dot)echerer(at)manroland-web(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | For@ll | 2015-02-04 07:01:15 | Lost statistics after restore database |
Previous Message | Luis Antonio Dias de Sá Junior | 2015-02-03 16:53:24 | BDR and Load Balance |