1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
|
Source: postgresql
Section: misc
Priority: optional
Maintainer: Oliver Elphick <Oliver.Elphick@lfix.co.uk>
Standards-Version: 3.2.1
Build-Depends: libncurses5-dev (>= 5.0), tcl8.3-dev, bison, python2.1-dev, perl (>= 5.6.0-16), libperl-dev, tk8.3-dev, sharutils, flex, debhelper (>= 2.0.86), libreadline4-dev (>= 4.2), libssl-dev, zlib1g-dev (>= 1:1.1.3), libpam-dev, unixodbc-dev
Package: postgresql
Architecture: any
Section: misc
Depends: ${shlibs:Depends}, ${LINUXPS}, debianutils (>= 1.13.1), postgresql-client,adduser (>= 3.34), libpgsql2 (>= 7.2)
Conflicts: postgres95,libpq1, postgresql-pl, postgresql-test, postgresql-contrib (<< 7.2), postgresql-client (<< 7.2), ecpg (<< 7.2), libpgtcl (<< 7.1)
Replaces: postgresql-pl,libpgtcl (<< 7.1),postgresql-client (<< 7.1.1-4)
Suggests: libpgperl,libpgjava,libpgtcl,postgresql-doc,postgresql-dev,postgresql-contrib,python-pygresql,ident-server,pgdocs,pgmonitor
Description: Object-relational SQL database, descended from POSTGRES.
PostgreSQL is an object-relational database, which supports a large part
of SQL-92. It is under continuous development and each release implements
more of the SQL standard, to the extent that it is now probably more compliant
than many commercial databases. It also supports some object-oriented
features.
.
As compared to MySQL, PostgreSQL is more fully featured - most importantly,
PostgreSQL supports transactions on all tables, something which is essential
to multi-user update of a database and referential integrity, which, equally,
is essential to a reliable database. The trade-off is that it can be slower,
though again, each release sees improvements in efficiency. For more
information, see <http://OpenACS.org/why-not-mysql.html>.
.
This package provides the backend features; you need postgresql-client or
some other front-end to be able to access them. A package providing
ident-server is needed if you want to authenticate remote connections with
identd.
Package: postgresql-client
Architecture: any
Section: misc
Depends: ${shlibs:Depends},libpgsql2 (>= 7.2-3)
Replaces: postgresql (<< 7.1.1-4)
Conflicts: postgresql (<<7.1.1-4)
Suggests: postgresql-doc,pgdocs
Description: Front-end programs for PostgreSQL
This package contains client and administrative programs for PostgreSQL:
these are the user front-end, psql, and scripts for creating and destroying
users and database schemas.
.
If you install PostgreSQL on a standalone machine, you need this package
too. On a network, you need it installed somewhere on the network, but
not necessarily on the same machine.
Package: postgresql-dev
Architecture: any
Section: devel
Depends: libpgsql2 (>= 7.2-3),libecpg3, libssl-dev
Conflicts: postgres95-dev,postgres95,libpq1
Suggests: postgresql-doc,postgresql,pgdocs
Description: Header files for libpq (postgresql library)
Header files for compiling C and C++ programs to link
with the libpgsql2 libraries in order to communicate with the PostgreSQL
database backend.
Package: libpgsql2
Architecture: any
Section: libs
Depends: ${shlibs:Depends}
Conflicts: libpq1,postgres95,libpgsql2.1,libpgsql2.2
Replaces: libpgsql2.2,postgresql (<< 7.1),libpgsql2.1
Provides: libpgsql2.1
Suggests: postgresql-doc,postgresql-client
Description: Shared library libpq.so.2 for PostgreSQL
C and C++ libraries to enable user programs to communicate with
the PostgreSQL database backend. The backend can be on another machine and
accessed through TCP/IP. This package obsoletes libpgsql2.1.
Package: libecpg3
Architecture: any
Section: libs
Depends: ${shlibs:Depends}
Conflicts: ecpg
Provides: ecpg
Description: Shared library libecpg.so.3 for PostgreSQL
libecpg is used by programs built with ecpg (Embedded PostgreSQL for C)
Use postgresql-dev to develop such programs.
Package: libpgtcl
Architecture: any
Section: libs
Depends: libpgsql2 (>= 7.2-3),tcl8.3 | tclsh,tk8.3 | wish,${shlibs:Depends}
Conflicts: postgresql-pl
Replaces: postgresql (<< 7.0-0.beta3), postgresql-pl
Suggests: postgresql-doc,pgaccess
Description: Tcl/Tk library and front-end for PostgreSQL.
A library to enable Tcl/Tk scripts to communicate with the
PostgreSQL database backend.
Package: postgresql-doc
Architecture: all
Section: doc
Suggests: doc-linux-html,pgdocs
Description: Documentation for the PostgreSQL database.
Contains all README files, user manual and examples for all PostgreSQL
packages. The manual is in HTML format. See packages pgdocs-pdf
and pgdocs-pdf-a4 for other formats.
Package: libpgperl
Architecture: any
Section: libs
Depends: libpgsql2 (>= 7.2-3),${perl:Depends}, ${shlibs:Depends}
Conflicts: postgresql-pl
Replaces: postgresql (<< 7.1), postgresql-pl
Suggests: postgresql-doc
Description: Perl modules for PostgreSQL.
A library to enable Perl scripts to communicate with the
PostgreSQL database backend.
Package: pgaccess
Architecture: any
Section: misc
Depends: libpgtcl (>= 7.1)
Description: Tk/Tcl front-end for PostgreSQL database
A Tk/Tcl program for X that provides a front-end to PostgreSQL. It can be
used to generate and store queries, views and new forms.
Package: postgresql-contrib
Architecture: any
Section: misc
Depends: libpgsql2 (>= 7.2-3),postgresql (>= 7.2),libpgperl (>= 7.2),${shlibs:Depends}
Suggests: postgresql-doc
Description: Additional facilities for PostgreSQL
The PostgreSQL contrib package provides several additional features for
the PostgreSQL database. contrib often serves as a testbed for features
before they are adopted into PostgreSQL proper:
.
array - Array iterator functions
btree_gist - B-Tree indexing using GiST (Generalised Search Tree)
chkpass - Password type for storing and comparing encrypted passwords
cube - Type for n-dimensional "cubes"
dbase - Inserts the contents of an xBase-style .dbf file into a
PostgreSQL table
dblink - Functions to return results from a remote database
earthdistance - Operator for computing the distance (in miles) between
two points on the earth's surface
findoidjoins - Finds the joins used by oid columns by examining the actual
values in the oid columns and row oids.
fulltextindex - Full text indexing using triggers
fuzzystrmatch - Functions for fuzzy string comparison (including Soundex)
intarray - RD-tree data structure using GiST index
isbn_issn - Type extensions for ISBN (books) and ISSN (serials)
lo - Large Object maintenance
mac - Maps MAC addresses to manufacture names
miscutil - Some utility functions
mysql - Conversion utilities for MySQL dumps
noupdate - Trigger to prevent updates on single columns
oid2name - Maps oids to table names
oracle - Conversion utility for Oracle database schemas
pgbench - A simple program to run a benchmark test
pg_controldata - Get information about the current database control data
pgcrypto - Cryptographic functions
pg_dumplo - Large Object dumper
pg_logger - Stdin to syslog gateway
pg_resetxlog - Partially recover a corrupted database by clearing the WAL
transaction log.
pgstattuple - Returns the percentage of dead tuples in a table; this
indicates whether a vacuum is required.
pg_upgrade - Migrate 7.1 database for initdb without requiring a full
dump and reload. Experimental!
retep - Java utilities for use with JDBC
rserv - Database replication
rtree_gist - R-Tree indexing using Generalised Search Tree algorithms
seg - Type representing laboratory measurements as floating-
point intervals
spi - PostgreSQL Server Programming Interface; 4 examples of
its use:
autoinc - A function for implementing AUTOINCREMENT/
IDENTITY
insert_username - function for inserting user names
moddatetime - Update modification timestamps
refint - Functions for implementing referential
integrity (foreign keys). Note that this is
now superseded by built-in referential
integrity.
timetravel - Re-implements in user code the time travel
feature that was removed in 6.3.
string - C-like input/output conversion routines for strings
tips - Micro HOWTOs
tsearch - Searchable text data type supporting indexed access
userlock - User-level long-term locks
vacuumlo - Vacuum deleted large objects
xml - Manipulate XML documents in the database
Package: python-pygresql
Architecture: any
Section: misc
Depends: libpgsql2 (>= 7.2-3),python (>= 2.1), python (<< 2.2), ${shlibs:Depends}, python2.1-egenix-mxdatetime
Description: PostgreSQL module for Python
PyGreSQL is a Python module that interfaces to a PostgreSQL database. It
embeds the PostgreSQL query library to allow easy use of the powerful
PostgreSQL features from a Python script.
Package: odbc-postgresql
Architecture: any
Section: libs
Depends: ${shlibs:Depends}
Suggests: unixodbc | libiodbc2
Description: ODBC support for PostgreSQL
Provides support for ODBC access to the PostgreSQL backend.
|
