2010/7/20 Devrim GÜNDÜZ <[email protected]>: > > 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
