From: Jerry Sievers <gsievers19@comcast.net>
To: pgsql-admin@postgresql.org
Subject: Restart time indication in cases of postmaster initiated all backend restart
Date: Mon, 26 Jun 2017 10:39:42 -0500
Message-ID: <87fuemzrk1.fsf@jsievers.enova.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Admins,
as per $subject, apart from server logs and/or client side diagnostics,
is there a way to query for event time when a crashed backend restart
happened?
Such an event does *not* result in postmaster itself restarting and thus
may lead to misleading confirmation of same.
DBAs may be inclined to select pg_postmaster_start_time() to confirm.
I have been aware of this fact for some time but I think less
experienced admins get thrown by it sometimes.
But to my question, is there some other function or equivalent method to
read this from inside the DB that I'm not aware of?
Thanks
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
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: gsievers19@comcast.net
Subject: Re: Restart time indication in cases of postmaster initiated all backend restart
In-Reply-To: <87fuemzrk1.fsf@jsievers.enova.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