How to Install and Uninstall postgresql-contrib-9.5 Package on Ubuntu 16.04 LTS (Xenial Xerus)
Last updated: November 26,2024
1. Install "postgresql-contrib-9.5" package
Please follow the guidelines below to install postgresql-contrib-9.5 on Ubuntu 16.04 LTS (Xenial Xerus)
$
sudo apt update
Copied
$
sudo apt install
postgresql-contrib-9.5
Copied
2. Uninstall "postgresql-contrib-9.5" package
Please follow the guidance below to uninstall postgresql-contrib-9.5 on Ubuntu 16.04 LTS (Xenial Xerus):
$
sudo apt remove
postgresql-contrib-9.5
Copied
$
sudo apt autoclean && sudo apt autoremove
Copied
3. Information about the postgresql-contrib-9.5 package on Ubuntu 16.04 LTS (Xenial Xerus)
Package: postgresql-contrib-9.5
Architecture: amd64
Version: 9.5.25-0ubuntu0.16.04.1
Priority: optional
Section: database
Source: postgresql-9.5
Origin: Ubuntu
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 2015
Depends: postgresql-9.5 (= 9.5.25-0ubuntu0.16.04.1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.25-0ubuntu0.16.04.1_amd64.deb
Size: 450506
MD5sum: ce42936bf8c901c56df1413ea0564839
SHA1: 210dce7aa522037dde9567dd8b9ed24a9ef667ec
SHA256: a92612f2fc9db5e62ef15ca9cee97bf5ac2026588474a79fc8da24f66eae8353
SHA512: aecba04dd5241fc1c986732d88ead1466edc90aa51fee180b1e511acd6aa45e2469692d7cedeae9c27a0ffc7120ec63f4c96f8fac1f867121134f00e358c24a1
Homepage: http://www.postgresql.org/
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Task: postgresql-server
Supported: 5y
Package: postgresql-contrib-9.5
Architecture: amd64
Version: 9.5.24-0ubuntu0.16.04.1
Priority: optional
Section: database
Source: postgresql-9.5
Origin: Ubuntu
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 2015
Depends: postgresql-9.5 (= 9.5.24-0ubuntu0.16.04.1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.24-0ubuntu0.16.04.1_amd64.deb
Size: 450026
MD5sum: 049baa97e783cd15692b6ba7979e77e2
SHA1: 9ba4f15f87f0f5498d38e5a94f2aa83434259383
SHA256: 2fcc3aebffe77cb27e579e7aaceea3e8b7b9a82707df8aba27d1fd1eefc63ba2
SHA512: 746a9dec55a2c5e828ed72c7104e62411cea5e3459a56816d19b43de273710b574aa52434186546f0d23975a2526741dbdb4524aab353814993bac225c6ca407
Homepage: http://www.postgresql.org/
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Task: postgresql-server
Supported: 5y
Package: postgresql-contrib-9.5
Priority: optional
Section: database
Installed-Size: 1998
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Architecture: amd64
Source: postgresql-9.5
Version: 9.5.2-1
Depends: postgresql-9.5 (= 9.5.2-1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.2-1_amd64.deb
Size: 445974
MD5sum: 45a2c7087ac2579880e62e23291f1053
SHA1: 3440872bce283a04f6dc0878f71fea8ba27e3dcc
SHA256: 000ffbb79367f12387d113a4cad4f892aa6998b54385315ede94a37f574fd81c
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Homepage: http://www.postgresql.org/
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Origin: Ubuntu
Supported: 5y
Task: postgresql-server
Architecture: amd64
Version: 9.5.25-0ubuntu0.16.04.1
Priority: optional
Section: database
Source: postgresql-9.5
Origin: Ubuntu
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 2015
Depends: postgresql-9.5 (= 9.5.25-0ubuntu0.16.04.1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.25-0ubuntu0.16.04.1_amd64.deb
Size: 450506
MD5sum: ce42936bf8c901c56df1413ea0564839
SHA1: 210dce7aa522037dde9567dd8b9ed24a9ef667ec
SHA256: a92612f2fc9db5e62ef15ca9cee97bf5ac2026588474a79fc8da24f66eae8353
SHA512: aecba04dd5241fc1c986732d88ead1466edc90aa51fee180b1e511acd6aa45e2469692d7cedeae9c27a0ffc7120ec63f4c96f8fac1f867121134f00e358c24a1
Homepage: http://www.postgresql.org/
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Task: postgresql-server
Supported: 5y
Package: postgresql-contrib-9.5
Architecture: amd64
Version: 9.5.24-0ubuntu0.16.04.1
Priority: optional
Section: database
Source: postgresql-9.5
Origin: Ubuntu
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Installed-Size: 2015
Depends: postgresql-9.5 (= 9.5.24-0ubuntu0.16.04.1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.24-0ubuntu0.16.04.1_amd64.deb
Size: 450026
MD5sum: 049baa97e783cd15692b6ba7979e77e2
SHA1: 9ba4f15f87f0f5498d38e5a94f2aa83434259383
SHA256: 2fcc3aebffe77cb27e579e7aaceea3e8b7b9a82707df8aba27d1fd1eefc63ba2
SHA512: 746a9dec55a2c5e828ed72c7104e62411cea5e3459a56816d19b43de273710b574aa52434186546f0d23975a2526741dbdb4524aab353814993bac225c6ca407
Homepage: http://www.postgresql.org/
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Task: postgresql-server
Supported: 5y
Package: postgresql-contrib-9.5
Priority: optional
Section: database
Installed-Size: 1998
Maintainer: Ubuntu Developers
Original-Maintainer: Debian PostgreSQL Maintainers
Architecture: amd64
Source: postgresql-9.5
Version: 9.5.2-1
Depends: postgresql-9.5 (= 9.5.2-1), 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), zlib1g (>= 1:1.1.4)
Suggests: libdbd-pg-perl
Filename: pool/main/p/postgresql-9.5/postgresql-contrib-9.5_9.5.2-1_amd64.deb
Size: 445974
MD5sum: 45a2c7087ac2579880e62e23291f1053
SHA1: 3440872bce283a04f6dc0878f71fea8ba27e3dcc
SHA256: 000ffbb79367f12387d113a4cad4f892aa6998b54385315ede94a37f574fd81c
Description-en: additional facilities for PostgreSQL
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.
Description-md5: 633a4e0645b2b02e72f77a260d0f4030
Homepage: http://www.postgresql.org/
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Origin: Ubuntu
Supported: 5y
Task: postgresql-server
4. References on Ubuntu 16.04 LTS (Xenial Xerus)
Popular Linux Distros
Ubuntu
Arch
Linux Mint
Fedora
Kali Linux
Debian
openSuSE
CentOS
Oracle Linux
Manjaro
Rocky Linux
AlmaLinux
Amazon Linux
Red Hat Enterprise Linux