Re: postgres uptime

Bruce Momjian wrote:
> Andreas Pflug wrote:

>>Guess what I just implemented...
>>
>>pg_postmaster_starttime() RETURNS timestamp, currently implemented in 
>>the admin module for win32  using GetProcessTimes(PostmasterHandle).
>>
>>What's the equivalent for posix? Interpreting popen("ps...") might get 
>>messy.
> 
> 
> I think we should just call gettimeofday() at postmaster start and store
> it somewhere.

Isn't the shared memory a good place ?

Regards
Gaetano Mendola