How To Check If Postgis Is Installed
Dear readers of our blog, we'd like to recommend y'all to visit the main page of our website, where yous can learn about our production SQLS*Plus and its advantages.
SQLS*Plus - best SQL Server command line reporting and automation tool! SQLS*Plus is several orders of magnitude better than SQL Server sqlcmd and osql command line tools.
Enteros UpBeat offers a patented database functioning management SaaS platform. It proactively identifies root causes of complex revenue-impacting database operation issues across a growing number of RDBMS, NoSQL, and deep/machine learning database platforms. Nosotros support Oracle, SQL Server, IBM DB2, MongoDB, Casandra, MySQL, Amazon Aurora, and other database systems.
25 September 2022
PostgreSQL, ofttimes referred to simply as Postgres, is a universal open up-source object and relational database direction system.
Knowing which version of the PostgreSQL server is installed and running in your system may be important in some situations. For example, if you are installing an application that requires a certain PostgreSQL version, you demand to find out which version of your PostgreSQL server yous are running.
In this article, nosotros will explain how to observe out which version of PostgreSQL server is running on your system.
PostgreSQL Version
PostgreSQL has versions in the following scheme:
MAJOR.MINOR
For example, in PostgreSQL 12.one 12 is the main version and 1 is the boosted version.
- MAJOR – Starting with PostgreSQL ten, each new major release increases a role of the MAJOR version past one, for example by 10, eleven, or 12. Prior to PostgreSQL 10, the major versions were represented past a decimal number, such every bit 9.0 or ix.half dozen.
- MINOR – The modest release number is the terminal part of the version number. For example, 11.4 and 11.6 are pocket-size versions, which are function of PostgreSQL version eleven 9.half-dozen.fifteen, and ix.vi.16 are part of PostgreSQL version 9.vi.
Major PostgreSQL releases with new features are usually released once a year. Each major release is supported for v years.
Command-line use
To observe out which PostgreSQL version works on your system, phone call the Postgres command with the -version or -Five parameter:
postgres --version
The control will print the PostgreSQL version:
postgres (PostgreSQL) 10.six
This case uses the PostgreSQL server version ten.6.
If the Postgres binary file is absent in the system PATH, you will get the error message "Postgres: command non found". This commonly happens when PostgreSQL bundle is not installed from standard distribution repositories.
You can find the path to the binary with the locate or detect command:
sudo detect /usr -wholename '*/bin/postgres'.
sudo updatedb
locate bin/postgres
The decision should wait like this:
/usr/lib/postgresql/9.6/bin/postgres
Once you lot find the path to the binary file, you can employ information technology to get a version of the PostgreSQL server:
/usr/lib/postgresql/9.half-dozen/bin/postgres -V
The version of the psql client utility in PostgreSQL tin exist institute with the following control:
psql --version
The conclusion will expect like this:
postgres (PostgreSQL) 10.6
psql is an interactive command-line utility that allows you lot to interact with the PostgreSQL server.
Using SQL shell
Some other mode to determine the version of the PostgreSQL server is to log in to the server SQL query and employ the SQL instruction to print the version.
Y'all can access the PostgreSQL trounce using a GUI client such as pgAdmin or using psql:
sudo -u postgres psql
The post-obit operator displays the PostgreSQL server version together with the build data:
Show server_version;
server_version
----------------
10.6
(one row)
Conclusion
In this article, we showed you lot several different options on how to discover the PostgreSQL server version running on your system.
Check PostgreSQL version
Tags: PostgreSQL, SQL
Source: https://www.sqlsplus.com/how-to-check-the-postgresql-version/
Posted by: riverashmed1979.blogspot.com
0 Response to "How To Check If Postgis Is Installed"
Post a Comment