postgresql-contrib-9.5_9.5.19-0ubuntu0.16.04.1_amd64.deb


Advertisement

Description

postgresql-contrib-9.5 - additional facilities for PostgreSQL

Property Value
Distribution Ubuntu 16.04 LTS (Xenial Xerus)
Repository Ubuntu Updates Main amd64
Package filename postgresql-contrib-9.5_9.5.19-0ubuntu0.16.04.1_amd64.deb
Package name postgresql-contrib-9.5
Package version 9.5.19
Package release 0ubuntu0.16.04.1
Package architecture amd64
Package type deb
Category database
Homepage http://www.postgresql.org/
License -
Maintainer Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Download size 438.12 KB
Installed size 1.96 MB
The PostgreSQL contrib package provides several additional features
for the PostgreSQL database. This version is built to work with the
server package postgresql-9.5.  contrib often serves as a testbed for
features before they are adopted into PostgreSQL proper:
adminpack      - File and log manipulation routines, used by pgAdmin
btree_gist     - B-Tree indexing using GiST (Generalised Search Tree)
chkpass        - An auto-encrypted password datatype
cube           - Multidimensional-cube datatype (GiST indexing example)
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
fuzzystrmatch  - Levenshtein, metaphone, and soundex fuzzy string matching
hstore         - Store (key, value) pairs
intagg         - Integer aggregator/enumerator
_int           - Index support for arrays of int4, using GiST (benchmark
needs the libdbd-pg-perl package)
isn            - type extensions for ISBN, ISSN, ISMN, EAN13 product numbers
lo             - Large Object maintenance
ltree          - Tree-like data structures
oid2name       - Maps OIDs to table names
pageinspect    - Inspection of database pages
passwordcheck  - Simple password strength checker
pg_buffercache - Real time queries on the shared buffer cache
pg_freespacemap- Displays the contents of the free space map (FSM)
pg_trgm        - Determine the similarity of text based on trigram matching
pg_standby     - Create a warm stand-by server
pgbench        - TPC-B like benchmark
pgcrypto       - Cryptographic functions
pgrowlocks     - A function to return row locking information
pgstattuple    - Returns the percentage of dead tuples in a table; this
indicates whether a vacuum is required.
postgresql_fdw - foreign data wrapper for PostgreSQL
seg            - Confidence-interval datatype (GiST indexing example)
sepgsql        - mandatory access control (MAC) based on SELinux
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.
tablefunc      - examples of functions returning tables
uuid-ossp      - UUID generation functions
vacuumlo       - Remove orphaned large objects
PostgreSQL is an object-relational SQL database management system.

Alternatives

Package Version Architecture Repository
postgresql-contrib-9.5_9.5.19-0ubuntu0.16.04.1_i386.deb 9.5.19 i386 Ubuntu Updates Main
postgresql-contrib-9.5_9.5.2-1_i386.deb 9.5.2 i386 Ubuntu Main
postgresql-contrib-9.5_9.5.2-1_amd64.deb 9.5.2 amd64 Ubuntu Main
postgresql-contrib-9.5 - - -

Requires

Name Value
libc6 >= 2.15
libpq5 >= 9.2~beta3
libselinux1 >= 2.1.12
libssl1.0.0 >= 1.0.0
libuuid1 >= 2.16
libxml2 >= 2.7.4
libxslt1.1 >= 1.1.25
postgresql-9.5 = 9.5.19-0ubuntu0.16.04.1
zlib1g >= 1:1.1.4

Download

Type URL
Mirror archive.ubuntu.com
Binary Package postgresql-contrib-9.5_9.5.19-0ubuntu0.16.04.1_amd64.deb
Source Package postgresql-9.5

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install postgresql-contrib-9.5 deb package:
    # sudo apt-get install postgresql-contrib-9.5

Files

Path
/usr/lib/postgresql/9.5/bin/oid2name
/usr/lib/postgresql/9.5/bin/pg_archivecleanup
/usr/lib/postgresql/9.5/bin/pg_standby
/usr/lib/postgresql/9.5/bin/pg_test_fsync
/usr/lib/postgresql/9.5/bin/pg_test_timing
/usr/lib/postgresql/9.5/bin/pgbench
/usr/lib/postgresql/9.5/bin/vacuumlo
/usr/lib/postgresql/9.5/lib/_int.so
/usr/lib/postgresql/9.5/lib/adminpack.so
/usr/lib/postgresql/9.5/lib/auth_delay.so
/usr/lib/postgresql/9.5/lib/auto_explain.so
/usr/lib/postgresql/9.5/lib/autoinc.so
/usr/lib/postgresql/9.5/lib/btree_gin.so
/usr/lib/postgresql/9.5/lib/btree_gist.so
/usr/lib/postgresql/9.5/lib/chkpass.so
/usr/lib/postgresql/9.5/lib/citext.so
/usr/lib/postgresql/9.5/lib/cube.so
/usr/lib/postgresql/9.5/lib/dblink.so
/usr/lib/postgresql/9.5/lib/dict_int.so
/usr/lib/postgresql/9.5/lib/dict_xsyn.so
/usr/lib/postgresql/9.5/lib/earthdistance.so
/usr/lib/postgresql/9.5/lib/file_fdw.so
/usr/lib/postgresql/9.5/lib/fuzzystrmatch.so
/usr/lib/postgresql/9.5/lib/hstore.so
/usr/lib/postgresql/9.5/lib/insert_username.so
/usr/lib/postgresql/9.5/lib/isn.so
/usr/lib/postgresql/9.5/lib/lo.so
/usr/lib/postgresql/9.5/lib/ltree.so
/usr/lib/postgresql/9.5/lib/moddatetime.so
/usr/lib/postgresql/9.5/lib/pageinspect.so
/usr/lib/postgresql/9.5/lib/passwordcheck.so
/usr/lib/postgresql/9.5/lib/pg_buffercache.so
/usr/lib/postgresql/9.5/lib/pg_freespacemap.so
/usr/lib/postgresql/9.5/lib/pg_prewarm.so
/usr/lib/postgresql/9.5/lib/pg_stat_statements.so
/usr/lib/postgresql/9.5/lib/pg_trgm.so
/usr/lib/postgresql/9.5/lib/pgcrypto.so
/usr/lib/postgresql/9.5/lib/pgrowlocks.so
/usr/lib/postgresql/9.5/lib/pgstattuple.so
/usr/lib/postgresql/9.5/lib/pgxml.so
/usr/lib/postgresql/9.5/lib/postgres_fdw.so
/usr/lib/postgresql/9.5/lib/refint.so
/usr/lib/postgresql/9.5/lib/seg.so
/usr/lib/postgresql/9.5/lib/sepgsql.so
/usr/lib/postgresql/9.5/lib/sslinfo.so
/usr/lib/postgresql/9.5/lib/tablefunc.so
/usr/lib/postgresql/9.5/lib/tcn.so
/usr/lib/postgresql/9.5/lib/test_decoding.so
/usr/lib/postgresql/9.5/lib/timetravel.so
/usr/lib/postgresql/9.5/lib/tsm_system_rows.so
/usr/lib/postgresql/9.5/lib/tsm_system_time.so
/usr/lib/postgresql/9.5/lib/unaccent.so
/usr/lib/postgresql/9.5/lib/uuid-ossp.so
/usr/share/doc/postgresql-contrib-9.5/autoinc.example
/usr/share/doc/postgresql-contrib-9.5/changelog.Debian.gz
/usr/share/doc/postgresql-contrib-9.5/copyright
/usr/share/doc/postgresql-contrib-9.5/insert_username.example
/usr/share/doc/postgresql-contrib-9.5/moddatetime.example
/usr/share/doc/postgresql-contrib-9.5/refint.example
/usr/share/doc/postgresql-contrib-9.5/timetravel.example
/usr/share/postgresql/9.5/contrib/sepgsql.sql
/usr/share/postgresql/9.5/extension/adminpack--1.0.sql
/usr/share/postgresql/9.5/extension/adminpack.control
/usr/share/postgresql/9.5/extension/autoinc--1.0.sql
/usr/share/postgresql/9.5/extension/autoinc--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/autoinc.control
/usr/share/postgresql/9.5/extension/btree_gin--1.0.sql
/usr/share/postgresql/9.5/extension/btree_gin--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/btree_gin.control
/usr/share/postgresql/9.5/extension/btree_gist--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/btree_gist--1.1.sql
/usr/share/postgresql/9.5/extension/btree_gist--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/btree_gist.control
/usr/share/postgresql/9.5/extension/chkpass--1.0.sql
/usr/share/postgresql/9.5/extension/chkpass--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/chkpass.control
/usr/share/postgresql/9.5/extension/citext--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/citext--1.1.sql
/usr/share/postgresql/9.5/extension/citext--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/citext.control
/usr/share/postgresql/9.5/extension/cube--1.0.sql
/usr/share/postgresql/9.5/extension/cube--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/cube.control
/usr/share/postgresql/9.5/extension/dblink--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/dblink--1.1.sql
/usr/share/postgresql/9.5/extension/dblink--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/dblink.control
/usr/share/postgresql/9.5/extension/dict_int--1.0.sql
/usr/share/postgresql/9.5/extension/dict_int--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/dict_int.control
/usr/share/postgresql/9.5/extension/dict_xsyn--1.0.sql
/usr/share/postgresql/9.5/extension/dict_xsyn--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/dict_xsyn.control
/usr/share/postgresql/9.5/extension/earthdistance--1.0.sql
/usr/share/postgresql/9.5/extension/earthdistance--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/earthdistance.control
/usr/share/postgresql/9.5/extension/file_fdw--1.0.sql
/usr/share/postgresql/9.5/extension/file_fdw.control
/usr/share/postgresql/9.5/extension/fuzzystrmatch--1.0.sql
/usr/share/postgresql/9.5/extension/fuzzystrmatch--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/fuzzystrmatch.control
/usr/share/postgresql/9.5/extension/hstore--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/hstore--1.1--1.2.sql
/usr/share/postgresql/9.5/extension/hstore--1.2--1.3.sql
/usr/share/postgresql/9.5/extension/hstore--1.3.sql
/usr/share/postgresql/9.5/extension/hstore--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/hstore.control
/usr/share/postgresql/9.5/extension/insert_username--1.0.sql
/usr/share/postgresql/9.5/extension/insert_username--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/insert_username.control
/usr/share/postgresql/9.5/extension/intagg--1.0.sql
/usr/share/postgresql/9.5/extension/intagg--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/intagg.control
/usr/share/postgresql/9.5/extension/intarray--1.0.sql
/usr/share/postgresql/9.5/extension/intarray--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/intarray.control
/usr/share/postgresql/9.5/extension/isn--1.0.sql
/usr/share/postgresql/9.5/extension/isn--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/isn.control
/usr/share/postgresql/9.5/extension/lo--1.0.sql
/usr/share/postgresql/9.5/extension/lo--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/lo.control
/usr/share/postgresql/9.5/extension/ltree--1.0.sql
/usr/share/postgresql/9.5/extension/ltree--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/ltree.control
/usr/share/postgresql/9.5/extension/moddatetime--1.0.sql
/usr/share/postgresql/9.5/extension/moddatetime--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/moddatetime.control
/usr/share/postgresql/9.5/extension/pageinspect--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pageinspect--1.1--1.2.sql
/usr/share/postgresql/9.5/extension/pageinspect--1.2--1.3.sql
/usr/share/postgresql/9.5/extension/pageinspect--1.3.sql
/usr/share/postgresql/9.5/extension/pageinspect--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pageinspect.control
/usr/share/postgresql/9.5/extension/pg_buffercache--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pg_buffercache--1.1.sql
/usr/share/postgresql/9.5/extension/pg_buffercache--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pg_buffercache.control
/usr/share/postgresql/9.5/extension/pg_freespacemap--1.0.sql
/usr/share/postgresql/9.5/extension/pg_freespacemap--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pg_freespacemap.control
/usr/share/postgresql/9.5/extension/pg_prewarm--1.0.sql
/usr/share/postgresql/9.5/extension/pg_prewarm.control
/usr/share/postgresql/9.5/extension/pg_stat_statements--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pg_stat_statements--1.1--1.2.sql
/usr/share/postgresql/9.5/extension/pg_stat_statements--1.2--1.3.sql
/usr/share/postgresql/9.5/extension/pg_stat_statements--1.3.sql
/usr/share/postgresql/9.5/extension/pg_stat_statements--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pg_stat_statements.control
/usr/share/postgresql/9.5/extension/pg_trgm--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pg_trgm--1.1.sql
/usr/share/postgresql/9.5/extension/pg_trgm--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pg_trgm.control
/usr/share/postgresql/9.5/extension/pgcrypto--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pgcrypto--1.1--1.2.sql
/usr/share/postgresql/9.5/extension/pgcrypto--1.2.sql
/usr/share/postgresql/9.5/extension/pgcrypto--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pgcrypto.control
/usr/share/postgresql/9.5/extension/pgrowlocks--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pgrowlocks--1.1.sql
/usr/share/postgresql/9.5/extension/pgrowlocks--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pgrowlocks.control
/usr/share/postgresql/9.5/extension/pgstattuple--1.0--1.1.sql
/usr/share/postgresql/9.5/extension/pgstattuple--1.1--1.2.sql
/usr/share/postgresql/9.5/extension/pgstattuple--1.2--1.3.sql
/usr/share/postgresql/9.5/extension/pgstattuple--1.3.sql
/usr/share/postgresql/9.5/extension/pgstattuple--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/pgstattuple.control
/usr/share/postgresql/9.5/extension/postgres_fdw--1.0.sql
/usr/share/postgresql/9.5/extension/postgres_fdw.control
/usr/share/postgresql/9.5/extension/refint--1.0.sql
/usr/share/postgresql/9.5/extension/refint--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/refint.control
/usr/share/postgresql/9.5/extension/seg--1.0.sql
/usr/share/postgresql/9.5/extension/seg--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/seg.control
/usr/share/postgresql/9.5/extension/sslinfo--1.0.sql
/usr/share/postgresql/9.5/extension/sslinfo--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/sslinfo.control
/usr/share/postgresql/9.5/extension/tablefunc--1.0.sql
/usr/share/postgresql/9.5/extension/tablefunc--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/tablefunc.control
/usr/share/postgresql/9.5/extension/tcn--1.0.sql
/usr/share/postgresql/9.5/extension/tcn.control
/usr/share/postgresql/9.5/extension/timetravel--1.0.sql
/usr/share/postgresql/9.5/extension/timetravel--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/timetravel.control
/usr/share/postgresql/9.5/extension/tsearch2--1.0.sql
/usr/share/postgresql/9.5/extension/tsearch2--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/tsearch2.control
/usr/share/postgresql/9.5/extension/tsm_system_rows--1.0.sql
/usr/share/postgresql/9.5/extension/tsm_system_rows.control
/usr/share/postgresql/9.5/extension/tsm_system_time--1.0.sql
/usr/share/postgresql/9.5/extension/tsm_system_time.control
/usr/share/postgresql/9.5/extension/unaccent--1.0.sql
/usr/share/postgresql/9.5/extension/unaccent--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/unaccent.control
/usr/share/postgresql/9.5/extension/uuid-ossp--1.0.sql
/usr/share/postgresql/9.5/extension/uuid-ossp--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/uuid-ossp.control
/usr/share/postgresql/9.5/extension/xml2--1.0.sql
/usr/share/postgresql/9.5/extension/xml2--unpackaged--1.0.sql
/usr/share/postgresql/9.5/extension/xml2.control
/usr/share/postgresql/9.5/man/man1/oid2name.1.gz
/usr/share/postgresql/9.5/man/man1/pg_archivecleanup.1.gz
/usr/share/postgresql/9.5/man/man1/pg_standby.1.gz
/usr/share/postgresql/9.5/man/man1/pg_test_fsync.1.gz
/usr/share/postgresql/9.5/man/man1/pg_test_timing.1.gz
/usr/share/postgresql/9.5/man/man1/pgbench.1.gz
/usr/share/postgresql/9.5/man/man1/vacuumlo.1.gz

Changelog

2019-08-06 - Christian Ehrhardt <christian.ehrhardt@canonical.com>
postgresql-9.5 (9.5.19-0ubuntu0.16.04.1) xenial-security; urgency=medium
* SECURITY UPDATE: New upstream release (LP: #1839058)
- Require schema qualification to cast to a temporary type when using
functional cast syntax (CVE-2019-10208)
- Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when altering multiple
columns' types in one command. This fixes a regression introduced in the
most recent minor releases
- Details about these and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-19.html
2019-06-18 - Christian Ehrhardt <christian.ehrhardt@canonical.com>
postgresql-9.5 (9.5.18-0ubuntu0.16.04.1) xenial; urgency=medium
* New upstream release (LP: #1833211)
- Fix failure of ALTER TABLE ... ALTER COLUMN TYPE when the table has
a partial exclusion constraint
- Fix failure of COMMENT command for comments on domain constraints
- Details about these and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-18.html
2019-05-07 - Christian Ehrhardt <christian.ehrhardt@canonical.com>
postgresql-9.5 (9.5.17-0ubuntu0.16.04.1) xenial-security; urgency=medium
* New upstream release(s) (LP: #1828012)
- Prevent row-level security policies from being bypassed via
selectivity estimators.
CVE-2019-10130
- Details about these and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-17.html
2019-02-12 - Christian Ehrhardt <christian.ehrhardt@canonical.com>
postgresql-9.5 (9.5.16-0ubuntu0.16.04.1) xenial; urgency=medium
* New upstream release(s) (LP: #1815665)
- By default, panic instead of retrying after fsync() failure, to avoid
possible data corruption. A new server parameter "guc-data-sync-retry"
has been added to control this;
- d/p/pg-9.5-Disallow-setting-client_min_messages-higher-than-ERR.patch:
to retain SRU stability this patch reverts one of the changes which
disabled the error suppression by setting client_min_messages to
fatal or panic. Overall that means no change to the handling of
client_min_messages due to this upload.
- Details about these and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-15.html
https://www.postgresql.org/docs/9.5/static/release-9-5-16.html

See Also

Package Description
postgresql-contrib_9.5+173ubuntu0.3_all.deb additional facilities for PostgreSQL (supported version)
postgresql-doc-9.5_9.5.19-0ubuntu0.16.04.1_all.deb documentation for the PostgreSQL database management system
postgresql-doc_9.5+173ubuntu0.3_all.deb documentation for the PostgreSQL database management system
postgresql_9.5+173ubuntu0.3_all.deb object-relational SQL database (supported version)
ppp-dev_2.4.7-1+2ubuntu1.16.04.1_all.deb Point-to-Point Protocol (PPP) - development files
ppp_2.4.7-1+2ubuntu1.16.04.1_amd64.deb Point-to-Point Protocol (PPP) - daemon
pptpd_1.4.0-7ubuntu0.2_amd64.deb PoPToP Point to Point Tunneling Server
printer-driver-brlaser_3-5~ubuntu1_amd64.deb printer driver for (some) Brother laser printers
procmail_3.22-25ubuntu0.16.04.1_amd64.deb Versatile e-mail processor
procps_3.3.10-4ubuntu2.4_amd64.deb /proc file system utilities
psmisc_22.21-2.1ubuntu0.1_amd64.deb utilities that use the proc file system
pulseaudio-module-bluetooth_8.0-0ubuntu3.10_amd64.deb Bluetooth module for PulseAudio sound server
pulseaudio-module-x11_8.0-0ubuntu3.10_amd64.deb X11 module for PulseAudio sound server
pulseaudio-utils_8.0-0ubuntu3.10_amd64.deb Command line tools for the PulseAudio sound server
pulseaudio_8.0-0ubuntu3.10_amd64.deb PulseAudio sound server
Advertisement
Advertisement