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

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

From: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
To: Gregor Trefs <Gregor(dot)Trefs(at)delphit(dot)com>, Peter_Lieu(at)bmc(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Looking for table in PostregSQL that contains Operating System and Processor information
Date: 2011-05-05 12:55:41
Message-ID: BANLkTi=rSV4czx6K0F4CupdVU0A=t9EbBA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>
>

In response to

Responses

pgsql-novice by date

Next:From: Richard BroersmaDate: 2011-05-05 15:14:05
Subject: None numeric exclusion constraints using GIST
Previous:From: Gregor TrefsDate: 2011-05-05 12:44:07
Subject: Re: Looking for table in PostregSQL that contains Operating System and Processor information

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