Menu
I'm in a corporate environment (running Debian Linux) and didn't install it myself. I access the databases using Navicat or phpPgAdmin (if that helps). I also don't have shell access to the server running the database.
509
Check Postgres Version from SQL Shell Type the following SQL statement within the prompt to check the current version: SELECT version(); The resulting output provides the full version and system information for the PostgreSQL server.
basically just type "systemctl status postgresql-xx" where xx is the version of your PostgreSQL instance. ex: systemctl status posgresql-10. 2. There can be situations where you don't remember which version of postgres you installed and checking the service status just doesn't work.
The Global development group has released several versions of PostgreSQL. The latest version of PostgreSQL version is 12.3.
Run this query from PostgreSQL:
SELECT version();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With