History File woes

From: Jamie Strachan <jstrachan(at)counterpath(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: History File woes
Date: 2015-08-10 18:46:10
Message-ID: 55C8F172.3040304@counterpath.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I have postgresql 9.3 running in hot standby mode with 2 servers.
(RedHat Enterprise Linux 6.5+)

Periodically, it seems that my pg_xlog/?????.history file disappears.
I have not figured out yet why.
At that point, the standby server cannot be restarted, or it fails
because it can't read the history file of the active server.
The active server cannot be restarted either.

So, I am trying to recover from this situation.

I managed to start the database back up by doing the following:
* shut down both servers.
* pg_resetxlog
* delete recovery.conf / recovery.done
* delete backup_label

The database is running, however it does not recreate the history file!

Is there some command I can use to tell postgres to recreate the history
file?

Any thoughts on why my history files are disappearing, or how to debug that?

This has impacted one customer so far, but I am seeing it a lot more now
on my lab systems.

Any help would be greatly appreciated!

--
Jamie Strachan
CounterPath Corporation

Browse pgsql-admin by date

  From Date Subject
Next Message Michael H 2015-08-11 08:38:05 Postgresql-9.1 CentOS7 effective_cache_size issue
Previous Message Kevin Grittner 2015-08-07 16:12:18 Re: Replication Cluster Monitoring