Thread: Looking for table in PostregSQL that contains Operating System and Processor information
Looking for table in PostregSQL that contains Operating System and Processor information
From
"Lieu, Peter"
Date:
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
Re: Looking for table in PostregSQL that contains Operating System and Processor information
From
Sean Davis
Date:
I think the answer is no.
Sean
On Wed, May 4, 2011 at 8:25 PM, Lieu, Peter <Peter_Lieu@bmc.com> wrote:
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
Re: Looking for table in PostregSQL that contains Operating System and Processor information
From
Grzegorz Szpetkowski
Date:
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@bmc.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
Re: Looking for table in PostregSQL that contains Operating System and Processor information
From
Gregor Trefs
Date:
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@bmc.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
Re: Looking for table in PostregSQL that contains Operating System and Processor information
From
Grzegorz Szpetkowski
Date:
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.Trefs@delphit.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@bmc.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 > >
Re: Looking for table in PostregSQL that contains Operating System and Processor information
From
"Lieu, Peter"
Date:
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@gmail.com] Sent: Thursday, May 05, 2011 5:56 AM To: Gregor Trefs; Lieu, Peter Cc: pgsql-novice@postgresql.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.Trefs@delphit.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@bmc.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 > >