Tuesday, June 23, 2015

How to check postgres version

There are two ways:

#1:
sudo -u postgres psql
psql (9.4.4)
Type "help" for help.

postgres=# \q

#2.
deploy@localhost:~/apps/your-app/current$ psql --version

psql (PostgreSQL) 9.4.4