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
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.
> 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
>> 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
>> 3. CPU
>> cat /proc/cpuinfo | grep "model name" | cut -d ':' -f 2 | tr -s ' '
>> Intel(R) Core(TM) xx CPU M xxx @ x.xxGHz
>> Grzegorz Szpetkowski
>> 2011/5/5 Lieu, Peter<Peter_Lieu(at)bmc(dot)com>:
>>> 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.
>>> Peter Lieu
In response to
pgsql-novice by date
|Next:||From: Richard Broersma||Date: 2011-05-05 15:14:05|
|Subject: None numeric exclusion constraints using GIST|
|Previous:||From: Gregor Trefs||Date: 2011-05-05 12:44:07|
|Subject: Re: Looking for table in PostregSQL that contains Operating
System and Processor information|