Re: Finding last checkpoint time

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding last checkpoint time
Date: 2010-07-23 02:28:45
Message-ID: 1279852064-sup-260@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Excerpts from Greg Sabino Mullane's message of jue jul 22 13:34:25 UTC 2010:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
> > Or you can use pg_controldata /path/to/pgdata and look
> > at "Time of latest checkpoint".
>
> Assuming your system is using English. Otherwise, you'll
> have to build a collection of .po strings as we did for
> check_postgres.pl. Needless to say, I'd greatly prefer
> some other way to grab the information!

Hmm, wouldn't have it been easier to set LC_MESSAGES to C before calling
pg_controldata?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message std pik 2010-07-23 04:23:31 Information Extract
Previous Message Andy Colson 2010-07-23 01:02:40 Re: psql problem