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