Hi Mark,
I took the output of the Postgresql. Please find the output:
Package: postgresql-8.3
State: installed
Automatically installed: no
Version: 8.3.9-0ubuntu8.10
Priority: optional
Section: misc
Maintainer: Martin Pitt <
martin.pitt@ubuntu.com>
Uncompressed Size: 14.2M
Depends: libc6 (>= 2.4), libcomerr2 (>= 1.01), libkrb53 (>= 1.6.dfsg.2),
libldap-2.4-2 (>= 2.4.7), libpam0g (>= 0.99.7.1), libpq5 (>=
8.3~beta1), libssl0.9.8 (>= 0.9.8f-5), libxml2 (>= 2.6.27),
postgresql-client-8.3, postgresql-common (>= 79), tzdata, ssl-cert,
locales
Suggests: oidentd | ident-server
Conflicts: postgresql (< 7.5)
Description: object-relational SQL database, version 8.3 server
PostgreSQL is a fully featured object-relational database management system.
It supports a large part of the SQL standard and is designed to be extensible
by users in many aspects. Some of the features are: ACID transactions, foreign
keys, views, sequences, subqueries, triggers, user-defined types and functions,
outer joins, multiversion concurrency control. Graphical user interfaces and
bindings for many programming languages are available as well.
This package provides the database server for PostgreSQL 8.3. Servers for other
major release versions can be installed simultaneously and are coordinated by
the postgresql-common package. A package providing ident-server is needed if
you want to authenticate remote connections with identd.
Regards,
Srinivas Naik
On Wed, May 5, 2010 at 1:21 AM, Mark Kirkwood
<mark.kirkwood@catalyst.net.nz> wrote:
On 05/05/10 13:15, Mark Kirkwood wrote:
Please log into postgres do:
SELECT version();
(and Robert suggested)
Should read *as* Robert suggested - sorry.
Also you could do this from the os:
$ aptitude show postgresql-8.3
which will display more detail for the version.
Cheers
Mark