Re: Looking for table in PostregSQL that contains Operating System and Processor information

Hi Grzegorz,

In my PostgreSQL, the select version() returns only:

"PostgreSQL 8.3.7, compiled by Visual C++ build 1500"

without OS/platform info like yours does.

Peter Lieu

-----Original Message-----
From: Grzegorz Szpetkowski [mailto:gszpetkowski(at)gmail(dot)com]
Sent: Thursday, May 05, 2011 5:56 AM
To: Gregor Trefs; Lieu, Peter
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Looking for table in PostregSQL that contains Operating System and Processor information

In such way you can determine OS and bit's of hardware in which
PostgreSQL were compilied, not current server.

For example I have Debian 5 and select version(); returns:

PostgreSQL 8.3.14 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Debian 4.3.2-1.1) 4.3.2

Regards,
Grzegorz Szpetkowski

2011/5/5 Gregor Trefs <Gregor(dot)Trefs(at)delphit(dot)com>:
> Isn't the version() function an easier way ?
> If you execute the command "SELECT version();" you will get something like
> "PostgreSQL 8.4.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit".
> Well, you don't get any information about your processor speed, but you can
> determine the OS and the bits of your processor.
> Maybe you can write a pspgsql function using some of the string manipulation
> functions and returning a convient record type, which you can use in your
> FROM clause.
>
> Regards,
> Gregor Trefs
>
> Am 05.05.2011 14:14, schrieb Grzegorz Szpetkowski:
>>
>> AFAIK PostgreSQL does not include such table, but with a little effort
>> you create it by yourself using server's system tools. For example in
>> Debian:
>>
>> 1. OS
>> lsb_release -ds
>> Debian GNU/Linux 5.0.8 (lenny)
>>
>> 2. Platform (i386/i486/i586/i686 means "32 bit" and x86_64 is "64 bit")
>> uname -m
>> i686
>>
>> 3. CPU
>> cat /proc/cpuinfo | grep "model name" | cut -d ':' -f 2 | tr -s ' '
>>  Intel(R) Core(TM) xx CPU M xxx @ x.xxGHz
>>
>> Regards,
>> Grzegorz Szpetkowski
>>
>> 2011/5/5 Lieu, Peter<Peter_Lieu(at)bmc(dot)com>:
>>>
>>> Hi,
>>>
>>>
>>>
>>> I am new to PostreqSQL and I would like to know if there is a table in
>>> PostregSQL database that contains the Operating System, Platform, and
>>> Processor information which the PostregSQL database server is running on.
>>>
>>>
>>>
>>> Thank you very much for taking my question.
>>>
>>>
>>>
>>> Regards,
>>>
>>> Peter Lieu
>
>