From: Jamie Strachan <jstrachan@counterpath.com>
To: pgsql-admin@postgresql.org
Subject: History File woes
Date: Mon, 10 Aug 2015 14:46:10 -0400
Message-ID: <55C8F172.3040304@counterpath.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jstrachan@counterpath.com
Subject: Re: History File woes
In-Reply-To: <55C8F172.3040304@counterpath.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox