O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required