+2Create an external table:
dbadmin=> create external table os_version (ver varchar(255)) as copy from '/etc/issue'; -- add node name to copy if you want it from any specific node . or any node
CREATE TABLE
dbadmin@node_1:~$ cat /etc/issue
Ubuntu 18.04.2 LTS \n \l
vsql
dbadmin=> select * from os_version;
Ubuntu 18.04.2 LTS n l
(1 row)
+2The above works on Debian/Ubuntu. For CentOS/RHEL, it's copy from '/etc/redhat-release'
For kernel build, try copy from '/proc/version'
It's already in the system tables.
select kernel_release, kernel_version from dc_startups;
kernel_release | kernel_version
----------------------------+-------------------------------------
3.10.0-327.36.1.el7.x86_64 | #1 SMP Sun Sep 18 13:04:29 UTC 2016
I would caution that a file like /etc/redhat-release is just a text file that can be contrived to say pretty much anything, and is therefore not as useful as the kernel release from /proc... and the kernel release from /proc is already captured in dc_startups.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
