| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | adey11(at)gmail(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How to determine date / time of last postmaster restart |
| Date: | 2005-09-07 18:01:00 |
| Message-ID: | 200509072001.01559.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
adey wrote:
> Please let me know if there is a way to determine when the Postmaster
> was last restarted?
If you have configured your server log to contain timestamps, that is
your best bet to look. In any case, the server log will tell when the
last shutdown was, so you can at least narrow down the time frame. You
can also use pg_controldata to check the time of last change to
pg_control (which is changed when the server starts).
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-09-07 19:29:53 | Re: [HACKERS] How to determine date / time of last postmaster restart |
| Previous Message | Tom Lane | 2005-09-07 17:12:20 | Re: pg_dump error... Follow up |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-07 18:01:55 | Re: uuid type for postgres |
| Previous Message | Tom Lane | 2005-09-07 17:52:35 | Re: uuid type for postgres |