[Info-ingres] Installation and Server start time

[Paul Mason]

or this:

\p\g
select min(date(gmt_timestamp(session_time))) from ima_server_sessions_extra
where session_time != 0
Executing . . .


┌─────────────────────────┐
│col1                     │
├─────────────────────────┤
│13-jun-2018 11:11:05     │
└─────────────────────────┘
(1 row)



On Thu, 21 Jun 2018 at 09:39 Paul Mason <latepaul at gmail.com> wrote:

> This works in imadb:
>
> * \p\g
> select date(gmt_timestamp(e.session_time)) from ima_server_sessions_extra
> e, ima_server_sessions s
> where
> e.server = s.server
> and e.session_id = s.session_id
> and s.session_name = ' <Dead Process Detector>'
> Executing . . .
>
>
> ┌─────────────────────────┐
> │col1                     │
> ├─────────────────────────┤
> │13-jun-2018 11:11:05     │
> └─────────────────────────┘
> (1 row)
>
> Note that there's a space at the beginning of the session name.
>
> On Thu, 21 Jun 2018 at 09:07 Martin Bowes <martin.bowes at ndph.ox.ac.uk>
> wrote:
>
>> Hi All,
>>
>>
>>
>> Is there some way I can ask the  server when it was started? When the
>> installation was started?
>>
>>
>>
>> There certainly isn’t a dbmsinfo setting which provides that detail in
>> 10.2.
>>
>>
>>
>> I’ve trawled through imadb and can’t see anything obvious to a bear with
>> little brain.
>>
>>
>>
>> The only thing I can come up with is grep ‘Server.*Startup’
>> $II_SYSTEM/ingres/files/errlog.log | tail -1
>>
>>
>>
>> And that sorta sucks.
>>
>>
>>
>> Any ideas?
>>
>>
>>
>> Martin Bowes
>> _______________________________________________
>> Info-ingres mailing list
>> Info-ingres at lists.planetingres.org
>> http://lists.planetingres.org/mailman/listinfo/info-ingres
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20180621/737d978b/attachment.html>