DBA Hub

📋Steps in this guide1/1

How to find postgres version

Below commands can be used to find postgres version:

postgresql configurationintermediate
by PostgreSQL
13 views
1

How to find postgres version

Below commands can be used to find postgres version:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
dbaclass=#
show server_version;
server_version
----------------
10.13
(1 row)
dbaclass=#
select version ();
version
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 10.13 on x86_64-apple-darwin, compiled by i686-apple-darwin11-llvm-gcc-4.2 (GCC) 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2336.11.00), 64-bit
(1 row)
postgres$ cd /Library/PostgreSQL/10/bin
postgres$
./postgres -V
postgres (PostgreSQL) 10.13
-- PG_VERSION file is under data directory
postgres$ cd /Library/PostgreSQL/10/data
postgres$
cat PG_VERSION
10

Comments (0)

Please to add comments

No comments yet. Be the first to comment!