On 06.12.2014, bruce@xxxxxxxxxx wrote: > You need to create new standbys after the upgrade --- pg_upgrade does not retain the WAL files from the previous cluster, as the format might have changed. I created a new standby (pg_start_backup(), rsync, ...) after the execution of pg_upgrade on the master. On the master is the timeline history missing and i get the following error message when I try to set up a streaming client: ... : could not receive timeline history file from the primary server: ERROR: could not open file "pg_xlog/00000002.history": No such file or directory 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. 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 entity to whom they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this eMail in error, then please delete this eMail. ! Please consider your environmental responsibility before printing this eMail ! ________________________________ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
