Missing timeline history file after execution of pg_upgrade - Mailing list pgsql-admin

From
Subject Missing timeline history file after execution of pg_upgrade
Date
Msg-id D5359E0908278642BB1747131D62694DAB22560F@AUSMXMBX01.mrws.biz
Whole thread Raw
Responses Re: Missing timeline history file after execution of pg_upgrade  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Hi,

after execution of pg_upgrade is the timeline history file (i.e. 00000002.history) in the new database cluster missing.
Therefore,it is no longer possible to use this database cluster as the master for a streaming replication client. 

Test description:
-----------------
- Running postgres database (Version 9.3.4)

- Setting Up WAL Archiving for this database named "Database A"

- Making a base backup of "Database A"

- Crash of "Database A"

- Do a recovering using a "Continuous archive backup" of "Database A"
  (new timeline is created)

- Listing of data/pg_xlog (Database A) after recovering
-- 16777216 Oct 22 13:36 000000010000000000000006
-- 16777216 Oct 22 13:36 000000010000000000000007
-- 16777216 Oct 22 13:36 000000010000000000000008
--       41 Oct 22 13:36 00000002.history
-- 16777216 Oct 22 13:36 000000020000000000000008
-- 16777216 Oct 22 13:38 000000020000000000000009
-- 16777216 Oct 22 13:54 00000002000000000000000A
-- 16777216 Oct 22 13:54 00000002000000000000000B
-- 16777216 Oct 22 13:54 00000002000000000000000C
--     4096 Oct 22 13:54 archive_status/

- Install a new Postgres database (Version 9.3.4) named "Database B"

- Data transfer using pg_upgrade (Database A -> Database B)
  (pg_upgrade is not necessary, but it would be a standard procedure, that should work also with the same Postgres
version)

- Listing of data/pg_xlog (Database B)
-- 16777216 Oct 29 06:00 00000002000000000000000D
-- 16777216 Nov  5 06:00 00000002000000000000000E
-- 16777216 Nov 10 14:08 00000002000000000000000F
--     4096 Oct 22 13:54 archive_status/

- Setup a streaming replication client named "Database C" on "Database B"

- 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 


I have three questions:
1) Why pg_upgrade changed the timeline informations?
2) How do I get replication (Database B -> Database C) working?
3) Is this behavior intended. Is there a workaround for me?

Please help me to troubleshoot this problem. I will feedback any required information.


Thanks in advance
Christian
________________________________
manroland web systems GmbH -- Managing Director: Joern Gosse
Registered Office: Augsburg -- Trade Register: AG Augsburg -- HRB-No.: 26816 -- VAT: DE281389840

Confidentiality note:
This eMail and any files transmitted with it are confidential and intended solely for the use of the individual or
entityto whom they are addressed. If you are not the intended recipient, you are hereby notified that any use or
disseminationof this communication is strictly prohibited. If you have received this eMail in error, then please delete
thiseMail. 

! Please consider your environmental responsibility before printing this eMail !
________________________________


pgsql-admin by date:

Previous
From: Alex Lai
Date:
Subject: Use up too much memory
Next
From: Mark Steben
Date:
Subject: pg_repack issues