Missing timeline history file after execution of pg_upgrade

Поиск
Список
Период
Сортировка
От
Тема Missing timeline history file after execution of pg_upgrade
Дата
Msg-id D5359E0908278642BB1747131D62694DAB22560F@AUSMXMBX01.mrws.biz
обсуждение исходный текст
Ответы Re: Missing timeline history file after execution of pg_upgrade
Список 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 по дате отправления:

Предыдущее
От: Alex Lai
Дата:
Сообщение: Use up too much memory
Следующее
От: Mark Steben
Дата:
Сообщение: pg_repack issues