What version is the server?
If you experience problems, then you'll need to double-check which version of the server you have. This will help you report a fault or to consult the correct version of the manual.
How to do it…
We will find out the version by directly querying the database server.
Connect to the database and issue the following command:
postgres # SELECT version();
You'll get a response that looks something like this:
PostgreSQL 9.4.0 on i686-pc-linux-gnu,compiled by gcc (Debian 4.7.2-5) 4.7.2, 32-bit
That's probably too much information all at once!
How it works…
The PostgreSQL server version's format is Major.Minor.Maintenance.
In some other software products, the Major release number is all you need to know, but with PostgreSQL, the ...
Get PostgreSQL 9 Administration Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
