On Tue, Nov 9, 2010 at 7:57 AM, Josh Berkus j...@agliodbs.com wrote:
The patch which I'm proposing is helpful for you?
http://archives.postgresql.org/pgsql-hackers/2010-11/msg00167.php
Depends. Is that the timestamp on the master (when it was synced), or
the timestamp on the standby (when
It's the former. The function which I'm proposing returns the timestamp
of the last replayed commit/abort log record. That timestamp is given
when the commit/abort log record is generated in the master.
That would be *extremely* helpful for all kinds of monitoring tools.
Please
On Sat, Nov 6, 2010 at 3:46 AM, Josh Berkus j...@agliodbs.com wrote:
I'm continuing in my efforts now to document how to deploy and manage
replication on our wiki. One of the things a DBA needs to do is to use
pg_current_xlog_location() (and related functions) to check how far
behind the
--On 5. November 2010 11:46:08 -0700 Josh Berkus j...@agliodbs.com wrote:
I'll work on some tools to make this a bit more palatable, but I
disagree with earlier assertions that we have the replication monitoring
done. There's still a *lot* of work to do.
While getting familiar with our
The patch which I'm proposing is helpful for you?
http://archives.postgresql.org/pgsql-hackers/2010-11/msg00167.php
Depends. Is that the timestamp on the master (when it was synced), or
the timestamp on the standby (when it was replayed)? It's only helpful
if it's the former.
--
On 6 November 2010 05:46, Josh Berkus j...@agliodbs.com wrote:
I'm continuing in my efforts now to document how to deploy and manage
replication on our wiki. One of the things a DBA needs to do is to use
pg_current_xlog_location() (and related functions) to check how far
behind the master the
Folks,
I'm continuing in my efforts now to document how to deploy and manage
replication on our wiki. One of the things a DBA needs to do is to use
pg_current_xlog_location() (and related functions) to check how far
behind the master the standby is.
However, there's some serious problems with
On Fri, Nov 5, 2010 at 2:46 PM, Josh Berkus j...@agliodbs.com wrote:
I'm continuing in my efforts now to document how to deploy and manage
replication on our wiki. One of the things a DBA needs to do is to use
pg_current_xlog_location() (and related functions) to check how far
behind the
On Fri, Nov 5, 2010 at 5:39 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Nov 5, 2010 at 2:46 PM, Josh Berkus j...@agliodbs.com wrote:
I'm continuing in my efforts now to document how to deploy and manage
replication on our wiki. One of the things a DBA needs to do is to use