Why does PostgreSQL's shell shows me a different OS version instead of my real operating system?

Question

When I execute the following command:

SELECT version();

I get:

PostgreSQL 9.6.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit

What does Red Hat 4.4.7-16 means? I am running PostgreSQL on Debian 9 so, why this shows me Red Hat instead?

How did you install this thing? It seems very odd you're using a RedHat built Postgres server. — tadman
– tadman, Commented Aug 28, 2017 at 19:07
I just followed the steps of PostgreSQL site, I downloaded the graphical installer directly from enterprisedb.com/downloads/postgres-postgresql-downloads#linux, I selected version 9.6 and Linux-x86-64 OS and I just downloaded this. Do I did something wrong? — Joseph Ramos
– Joseph Ramos, Commented Aug 28, 2017 at 19:50

rmuller · Accepted Answer · 2017-08-28 19:48:19Z

1

It does not report your OS, but the software it was compiled with, i.e. GCC compiler version 4.4.7. More specifically: 4.4.7-16 (update 16) on Red Hat OS.

Your are running on x86_64-pc-linux-gnu (that is Debian 9 I suspect). See uname -a.

Just checked one of our servers (Debian 8):

PostgreSQL 9.6.4 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit

So, the Debian version should be built on Debian. See comment tadman.

edited Aug 28, 2017 at 19:48

answered Aug 28, 2017 at 19:04

rmuller

13k4 gold badges76 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why does PostgreSQL's shell shows me a different OS version instead of my real operating system?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related