Re: Reg: SQL Query for Postgres 8.4.3 - Mailing list pgsql-hackers

From Srinivas Naik
Subject Re: Reg: SQL Query for Postgres 8.4.3
Date
Msg-id r2r2e482c091005050313lb4f68a2ajade1eebc0e7a39b1@mail.gmail.com
Whole thread Raw
In response to Re: Reg: SQL Query for Postgres 8.4.3  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: Reg: SQL Query for Postgres 8.4.3
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Robert Haas
Date:
Subject: Re: max_standby_delay considered harmful