O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

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

Connect to the database, and then issue the following:

postgres # SELECT version();

You'll get a response with something like the following:

PostgreSQL 9.0 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Ubuntu 4.3.3-5ubuntu4) 4.3.3, 64-bit

That's probably too much information all at once!

How it works...

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 feature set and compatibility relates to the Major.Minor ...

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