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 to 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:

1. Connect to the database and issue the following command:

postgres # SELECT version();

2. You'll get a response that looks something like this:

PostgreSQL 10.2 on x86_64-apple-darwin16.7.0,
 compiled by Apple LLVM version 9.0.0 (clang-900.0.39.2), 64-bit

That's probably too much information all at once!

How it works…

The current PostgreSQL server version format is Major.Maintenance, from 10 onward. The first release was 10.0, and subsequent maintenance releases will be 10.1, 10.2, 10.3, and so on.

Prior to release 10, PostgreSQL used a three-part numbering series, meaning that the feature set and compatibility related to the Major.Minor release level. What this means is that version 9.4 contains more additional...