Re: Expose checkpoint start/finish times into SQL.

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-patches(at)postgresql(dot)org, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Theo Schlossnagle <jesus(at)omniti(dot)com>
Subject: Re: Expose checkpoint start/finish times into SQL.
Date: 2008-04-04 01:16:45
Message-ID: 20080403181645.4890d932@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 03 Apr 2008 20:45:37 -0400
Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:

> > Exposing everything into the log files isn't always sufficient
> > (says the guy who maintains a remote admin tool)
> >
>
> It should be now that you can have machine readable logs (says the
> guy who literally spent weeks making that happen) ;-)

And how does the person get access to those? And what script do I need
to write to make it happen? Don't get me wrong, the feature you worked
entirely too hard on to get working is valuable but... being able to
say, "SELECT * FROM give_me_my_db_info;" is much more useful in this
context.

In short, I should never have to go to log for this class of
information. It should be available in the database.

Sincerely,

Joshua D. Drake

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH9YF9ATb/zqfZUUQRAp+fAKCIOOKCKv5FaWiOF7hZjtLr8PzfGQCfRpq+
lY353B+9fmWwxWppAkhncMY=
=BwYD
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-04-04 01:26:46 Re: Expose checkpoint start/finish times into SQL.
Previous Message Joshua D. Drake 2008-04-04 01:14:57 Re: Expose checkpoint start/finish times into SQL.