Oliver <ofabelo@gmail.com> wrote:
> $ more PG_VERSION
> 9.3
If you can start the databased service and connect to it, the best
way to check the version is:
SELECT version();
If you can't start the service, you can do this:
$ postgres --version
(You may need to specify the path to the postgres executable.)
Either way you should be able to determine the minor release. It
is always a good idea to keep up-to-date on minor releases (where
the version number only changes to the right of the second dot),
because in PostgreSQL we only include fixes for serious bugs and
security vulnerabilities in minor releases, not new features. See
this page for additional discussion of the issue:
http://www.postgresql.org/support/versioning/
This is even more important than usual for 9.3, which had some data
corruption bugs in early versions.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company