2010/7/20 Devrim GÜNDÜZ <devrim@xxxxxxxxxx>: > > Is there a way to find last checkpoint time via SQL command? I know I > can grep xlogs by turning on log_checkpoints, but I'd prefer an SQL > solution. > > -- Or you can use pg_controldata /path/to/pgdata and look at "Time of latest checkpoint". I don't know of any other way, not to say there isn't one. Thom -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general