Which is the Postgres version

Question

I have a doubt about my version of Postgres installed in my environment.

This is my os: CentOS Linux release 7.3.1611 (Core) In /usr/ I can see: pgsql-9.4/ folder.

But when I do: select version(); I get:

PostgreSQL 9.2.18 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 
20150623 (Red Hat 4.8.5-11), 64-bit

So, what version do I have?

Possible duplicate of Which version of PostgreSQL am I running? — Abdollah
– Abdollah, Commented Oct 24, 2019 at 3:29

jmelesky · Accepted Answer · 2017-06-08 15:57:43Z

17

To determine the version of the database server, use select version() (from a connection to the database):

postgres=# select version();
                                                version                                                     
----------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.2.14 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit

To determine the version of the database client, use psql --version (from your shell command line):

$ psql --version
psql (PostgreSQL) 9.6.2

The server is where data is stored. The client is the software you use to connect to the server. They can be different versions.

answered Jun 8, 2017 at 15:57

jmelesky

4,1101 gold badge26 silver badges25 bronze badges

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

2 Comments

Sajjan Kumar Over a year ago

Hi, I am getting these with Select version() --> PostgreSQL 11devel. With psql --version ----> psql (PostgreSQL) 11devel but when I do postgres -V '---->' postgre 9.6.6 (why?).. Any Idea?

jmelesky Over a year ago

You likely have two different postgres installs, and a PATH that includes both directories. This is probably its own question, though, not a comment on a two year old post. :)

Ali Tourani · Accepted Answer · 2019-02-06 09:26:15Z

1

Simply check the version by this command: psql --version

answered Feb 6, 2019 at 9:26

Ali Tourani

1,2673 gold badges23 silver badges34 bronze badges

Comments

Slumdog · Accepted Answer · 2017-06-09 05:31:49Z

0

You may of course have more than one instance of Postgresql. Try this sql to show your current instance location in case there is more than one

SHOW data_directory;

edited Jun 9, 2017 at 5:31

user330315

answered Jun 9, 2017 at 2:24

Slumdog

4702 silver badges5 bronze badges

Collectives™ on Stack Overflow

Which is the Postgres version

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related