Skip site navigation (1) Skip section navigation (2)

Patch for Postmaster Uptime (from the TODO)

From: "Eric Crampton" <escpg(at)eonomine(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Patch for Postmaster Uptime (from the TODO)
Date: 2005-02-24 22:49:00
Message-ID: 39796.207.171.180.101.1109285340.spork@webmail.eonomine.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Hello hackers,

I noticed in the TODO that there is an item requesting a function which
returns the uptime of the postmaster. I've wanted that as well. So, I've
added just such a thing: server_start_time(). This function returns the
time when the postmaster was started; a simple now() - server_start_time()
returns the uptime.

The below patches are for four files:

* postmaster.c: Now calls a new function, MarkServerStartTime(), before
calling ServerLoop().

* timestamp.h/timestamp.c: New functions: MarkServerStartTime() (called
from postmaster.c) and server_start_time(), a new SQL function which may
be called.

* pg_proc.h: Added DATA and DESCR to the very end of the list (OID=2557)
for the server_start_time function.

I didn't bother to include the generated fmgroids.h and fmgrtab.c. Since
they are small, I've attached the four unified diffs against the 8.0.1
code. Let me know if there's anything different the code should have done.

--Eric

Attachment: timestamp.h.diff
Description: application/octet-stream (410 bytes)
Attachment: timestamp.c.diff
Description: application/octet-stream (1.2 KB)
Attachment: postmaster.c.diff
Description: application/octet-stream (337 bytes)
Attachment: pg_proc.h.diff
Description: application/octet-stream (609 bytes)

Responses

pgsql-hackers by date

Next:From: Neil ConwayDate: 2005-02-24 23:03:28
Subject: Re: psql: recall previous command?
Previous:From: Tom LaneDate: 2005-02-24 22:47:44
Subject: Re: [NOVICE] Question on TRUNCATE privleges

pgsql-patches by date

Next:From: Ron MayerDate: 2005-02-24 23:08:34
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Previous:From: Ron MayerDate: 2005-02-24 22:43:45
Subject: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group