Postgresql数据库是一个高性能的全功能的开源关系型数据库，这里讲解一下如何在Linux mint 18.x 下安装 Postgresql 10，考虑到Linux mint 18.x是基于Ubuntu 16.04 LTS构建的，所以本文也完全适用于Ubuntu 16.04 LTS。
添加软件源
wget -q -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
更新本地缓存
apt update
安装
查找postgresql10安装包
lwk@qwfys ~ $ apt list |grep postgresql
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
akonadi-backend-postgresql/xenial,xenial 4:15.12.3-0ubuntu6 all
autopostgresqlbackup/xenial,xenial 1.0-7 all
bareos-database-postgresql/xenial 14.2.6-3 amd64
cl-sql-postgresql/xenial,xenial 6.7.0-1build1 all
cl-sql-postgresql-socket/xenial,xenial 6.7.0-1build1 all
clisp-module-postgresql/xenial 1:2.49-9ubuntu1 amd64
courier-authlib-postgresql/xenial 0.66.4-3build1 amd64
dsyslog-module-postgresql/xenial 0.6.0+nmu2ubuntu2 amd64
eekboek-db-postgresql/xenial,xenial 2.02.04+dfsg-2 all
freeradius-postgresql/xenial-updates,xenial-security 2.2.8+dfsg-0.1ubuntu0.1 amd64
gambas3-gb-db-postgresql/xenial-updates 3.8.4-2ubuntu3.1 amd64
gforge-db-postgresql/xenial,xenial 6.0.3+20151023-1ubuntu1 all
gforge-shell-postgresql/xenial,xenial 6.0.3+20151023-1ubuntu1 all
gnustep-dl2-postgresql-adaptor/xenial 0.12.0-13 amd64
libcppdb-postgresql0/xenial 0.3.1+dfsg-3build1 amd64
libghc-haskelldb-hdbc-postgresql-dev/xenial 2.1.2-7build1 amd64
libghc-haskelldb-hdbc-postgresql-doc/xenial,xenial 2.1.2-7build1 all
libghc-haskelldb-hdbc-postgresql-prof/xenial 2.1.2-7build1 amd64
libghc-hdbc-postgresql-dev/xenial 2.3.2.3-2build1 amd64
libghc-hdbc-postgresql-doc/xenial,xenial 2.3.2.3-2build1 all
libghc-hdbc-postgresql-prof/xenial 2.3.2.3-2build1 amd64
libghc-persistent-postgresql-dev/xenial 2.2.1.2-1build1 amd64
libghc-persistent-postgresql-doc/xenial,xenial 2.2.1.2-1build1 all
libghc-persistent-postgresql-prof/xenial 2.2.1.2-1build1 amd64
libghc-postgresql-libpq-dev/xenial 0.9.1.1-3 amd64
libghc-postgresql-libpq-doc/xenial,xenial 0.9.1.1-3 all
libghc-postgresql-libpq-prof/xenial 0.9.1.1-3 amd64
libghc-postgresql-simple-dev/xenial 0.5.1.2-1build1 amd64
libghc-postgresql-simple-doc/xenial,xenial 0.5.1.2-1build1 all
libghc-postgresql-simple-prof/xenial 0.5.1.2-1build1 amd64
libpostgresql-gst/xenial,xenial 3.2.5-1build2 all
libpostgresql-jdbc-java/xenial,xenial 9.2-1002-1 all
libpostgresql-jdbc-java-doc/xenial,xenial 9.2-1002-1 all
libpostgresql-ocaml/xenial 2.0.5-2build1 amd64
libpostgresql-ocaml-dev/xenial 2.0.5-2build1 amd64
librdf-storage-postgresql/xenial 1.0.17-1build1 amd64
libreoffice-sdbc-postgresql/xenial-updates,xenial-security 1:5.1.6~rc2-0ubuntu1~xenial3 amd64
libsoci-postgresql3.2v5/xenial 3.2.3-1ubuntu2 amd64
lua-dbi-postgresql/xenial 0.5.hg5ba1dd988961-3build1 amd64
lua-dbi-postgresql-dbg/xenial 0.5.hg5ba1dd988961-3build1 amd64
lua-dbi-postgresql-dev/xenial 0.5.hg5ba1dd988961-3build1 amd64
odbc-postgresql/xenial-pgdg 1:10.02.0000-1.pgdg16.04+1 amd64
odbc-postgresql-dbg/xenial 1:09.03.0300-1 amd64
perdition-postgresql/xenial 2.1-2build1 amd64
postgresql/xenial-pgdg,xenial-pgdg 10+191.pgdg16.04+1 all
postgresql-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-10-amcheck/xenial-pgdg 1.3-1.pgdg16.04+1 amd64
postgresql-10-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-10-bgw-replstatus/xenial-pgdg 1.0.2.pgdg16.04+1 amd64
postgresql-10-citus/xenial-pgdg 7.3.0.PGDG-1.pgdg16.04+1 amd64
postgresql-10-cron/xenial-pgdg 1.0.2-1.pgdg16.04+1 amd64
postgresql-10-dbg/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-10-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-10-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-10-hll/xenial-pgdg 2.10.2-1.pgdg16.04+1 amd64
postgresql-10-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-10-ip4r/xenial-pgdg 2.2-2.pgdg16.04+1 amd64
postgresql-10-jsquery/xenial-pgdg 1.0.1-1.pgdg16.04+1 amd64
postgresql-10-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-10-MysqL-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-10-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-10-orafce/xenial-pgdg 3.6.1-1.pgdg16.04+1 amd64
postgresql-10-partman/xenial-pgdg 3.1.3-1.pgdg16.04+1 amd64
postgresql-10-pgaudit/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-10-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-10-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-10-pgl-ddl-deploy/xenial-pgdg 1.3.0-1.pgdg16.04+1 amd64
postgresql-10-pglogical/xenial-pgdg 2.2.0-1.pgdg16.04+1 amd64
postgresql-10-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-10-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-10-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-10-pgq-node/xenial-pgdg,xenial-pgdg 3.2.5-1.pgdg16.04+1 all
postgresql-10-pgq3/xenial-pgdg 3.2.6-7.pgdg16.04+1 amd64
postgresql-10-pgrouting/xenial-pgdg 2.6.0-1.pgdg16.04+1 amd64
postgresql-10-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-10-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-10-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-10-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-10-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-10-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-10-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-10-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-10-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-10-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-10-postgis-2.4/xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-10-postgis-2.4-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-10-postgis-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-10-powa/xenial-pgdg 3.1.1.pgdg16.04+1 amd64
postgresql-10-prefix/xenial-pgdg 1.2.7-1.pgdg16.04+1 amd64
postgresql-10-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-10-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-10-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-10-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-10-repack/xenial-pgdg 1.4.2-2.pgdg16.04+1 amd64
postgresql-10-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-10-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-10-rum/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-10-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-10-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+2 amd64
postgresql-10-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-10-unit/xenial-pgdg 6.0-1.pgdg16.04+1 amd64
postgresql-10-wal2json/xenial-pgdg 1.0-2.pgdg16.04+1 amd64
postgresql-11-amcheck/xenial-pgdg 1.3-1.pgdg16.04+1 amd64
postgresql-11-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-11-bgw-replstatus/xenial-pgdg 1.0.2.pgdg16.04+1 amd64
postgresql-11-cron/xenial-pgdg 1.0.2-1.pgdg16.04+1 amd64
postgresql-11-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-11-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-11-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-11-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-11-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-11-orafce/xenial-pgdg 3.6.0-1.pgdg16.04+1 amd64
postgresql-11-partman/xenial-pgdg 3.1.2-1.pgdg16.04+1 amd64
postgresql-11-pgaudit/xenial-pgdg 1.1.1-2.pgdg16.04+1 amd64
postgresql-11-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-11-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-11-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-11-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-11-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-11-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-11-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-11-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-11-powa/xenial-pgdg 3.1.1.pgdg16.04+1 amd64
postgresql-11-prefix/xenial-pgdg 1.2.6-1.pgdg16.04+1 amd64
postgresql-11-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-11-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-11-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-11-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-11-rum/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-11-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-11-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-11-unit/xenial-pgdg 6.0-1.pgdg16.04+1 amd64
postgresql-11-wal2json/xenial-pgdg 1.0-2.pgdg16.04+1 amd64
postgresql-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-9.1-asn1oid/xenial-pgdg 0.0.20100818-3.5.pgdg16.04+1 amd64
postgresql-9.1-dbg/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-9.1-debversion/xenial-pgdg 1.0.8-2.pgdg16.04+1 amd64
postgresql-9.1-ip4r/xenial-pgdg 2.1.1-1.pgdg16.04+1 amd64
postgresql-9.1-mimeo/xenial-pgdg,xenial-pgdg 1.4.4-1.pgdg16.04+1 all
postgresql-9.1-pgextwlist/xenial-pgdg 1.5-1.pgdg16.04+1 amd64
postgresql-9.1-pgfincore/xenial-pgdg 1.2-2.pgdg16.04+1 amd64
postgresql-9.1-pgmemcache/xenial-pgdg 2.3.0-3.pgdg16.04+1 amd64
postgresql-9.1-pgmp/xenial-pgdg 1.0.2-3.pgdg16.04+1 amd64
postgresql-9.1-pgq3/xenial-pgdg 3.2.6-5.pgdg16.04+1 amd64
postgresql-9.1-pgrouting/xenial-pgdg 2.2.4-1.pgdg16.04+1 amd64
postgresql-9.1-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.3.0-1.pgdg16.04+1 all
postgresql-9.1-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-2.pgdg16.04+1 all
postgresql-9.1-pllua/xenial-pgdg 1:1.0-9.pgdg16.04+1 amd64
postgresql-9.1-plproxy/xenial-pgdg 2.7-1.pgdg16.04+1 amd64
postgresql-9.1-plr/xenial-pgdg 1:8.3.0.17-1.pgdg16.04+1 amd64
postgresql-9.1-plsh/xenial-pgdg 1.20140221-5.pgdg16.04+1 amd64
postgresql-9.1-plv8/xenial-pgdg 1:1.4.8.ds-2.pgdg16.04+1 amd64
postgresql-9.1-postgis-2.2/xenial-pgdg 2.2.2+dfsg-5.pgdg16.04+1 amd64
postgresql-9.1-postgis-2.2-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-5.pgdg16.04+1 all
postgresql-9.1-postgis-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-5.pgdg16.04+1 all
postgresql-9.1-prefix/xenial-pgdg 1.2.5-1.pgdg16.04+1 amd64
postgresql-9.1-preprepare/xenial-pgdg 0.8-1.pgdg16.04+1 amd64
postgresql-9.1-prioritize/xenial-pgdg 1.0.4-1.3.pgdg16.04+1 amd64
postgresql-9.1-slony1-2/xenial-pgdg 2.2.5-1.pgdg16.04+4 amd64
postgresql-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-9.2-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-9.2-dbg/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-9.2-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.2-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-9.2-ip4r/xenial-pgdg 2.2-1.pgdg16.04+1 amd64
postgresql-9.2-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-1.pgdg16.04+1 all
postgresql-9.2-orafce/xenial-pgdg 3.4.0-2~31.git07b8643.pgdg16.04+1 amd64
postgresql-9.2-pgespresso/xenial-pgdg 1.2-3.pgdg16.04+1 amd64
postgresql-9.2-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-9.2-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-9.2-pgmemcache/xenial-pgdg 2.3.0-3.pgdg16.04+1 amd64
postgresql-9.2-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-9.2-pgq3/xenial-pgdg 3.2.6-5.pgdg16.04+1 amd64
postgresql-9.2-pgrouting/xenial-pgdg 2.5.0-2~exp1.pgdg16.04+1 amd64
postgresql-9.2-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.5.0-2~exp1.pgdg16.04+1 all
postgresql-9.2-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.5.0-2~exp1.pgdg16.04+1 all
postgresql-9.2-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-9.2-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-9.2-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-9.2-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-9.2-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-9.2-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-9.2-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-9.2-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-9.2-postgis-2.2/xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 amd64
postgresql-9.2-postgis-2.2-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 all
postgresql-9.2-postgis-2.3/xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 amd64
postgresql-9.2-postgis-2.3-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.2-postgis-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.2-prefix/xenial-pgdg 1.2.6-1.pgdg16.04+1 amd64
postgresql-9.2-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-9.2-prioritize/xenial-pgdg 1.0.4-1.3.pgdg16.04+1 amd64
postgresql-9.2-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.2-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.2-q3c/xenial-pgdg 1.5.0-2.pgdg16.04+1 amd64
postgresql-9.2-similarity/xenial-pgdg 1.0~20160916-1.pgdg16.04+1 amd64
postgresql-9.2-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+1 amd64
postgresql-9.2-toastinfo/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-9.3-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-9.3-dbg/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-9.3-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.3-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-9.3-hll/xenial-pgdg 2.10.2-1.pgdg16.04+1 amd64
postgresql-9.3-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-9.3-ip4r/xenial-pgdg 2.2-2.pgdg16.04+1 amd64
postgresql-9.3-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-9.3-MysqL-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.3-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-9.3-orafce/xenial-pgdg 3.6.1-1.pgdg16.04+1 amd64
postgresql-9.3-pgespresso/xenial-pgdg 1.2-3.pgdg16.04+1 amd64
postgresql-9.3-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-9.3-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-9.3-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-9.3-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-9.3-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-9.3-pgq-node/xenial-pgdg,xenial-pgdg 3.2.5-1.pgdg16.04+1 all
postgresql-9.3-pgq3/xenial-pgdg 3.2.6-7.pgdg16.04+1 amd64
postgresql-9.3-pgrouting/xenial-pgdg 2.6.0-1.pgdg16.04+1 amd64
postgresql-9.3-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.3-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.3-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-9.3-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-9.3-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-9.3-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-9.3-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-9.3-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-9.3-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-9.3-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-9.3-postgis-2.2/xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 amd64
postgresql-9.3-postgis-2.2-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 all
postgresql-9.3-postgis-2.3/xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 amd64
postgresql-9.3-postgis-2.3-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.3-postgis-2.4/xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-9.3-postgis-2.4-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.3-postgis-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.3-prefix/xenial-pgdg 1.2.7-1.pgdg16.04+1 amd64
postgresql-9.3-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-9.3-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-9.3-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.3-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.3-q3c/xenial-pgdg 1.5.0-2.pgdg16.04+1 amd64
postgresql-9.3-repack/xenial-pgdg 1.4.2-2.pgdg16.04+1 amd64
postgresql-9.3-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.3-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.3-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-9.3-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+2 amd64
postgresql-9.3-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-9.4-amcheck/xenial-pgdg 1.3-1.pgdg16.04+1 amd64
postgresql-9.4-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-9.4-citus/xenial-pgdg 5.1.1-1.pgdg16.04+1 amd64
postgresql-9.4-dbg/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-9.4-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.4-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-9.4-hll/xenial-pgdg 2.10.2-1.pgdg16.04+1 amd64
postgresql-9.4-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-9.4-ip4r/xenial-pgdg 2.2-2.pgdg16.04+1 amd64
postgresql-9.4-jsquery/xenial-pgdg 1.0.1-1.pgdg16.04+1 amd64
postgresql-9.4-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-9.4-MysqL-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.4-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-9.4-orafce/xenial-pgdg 3.6.1-1.pgdg16.04+1 amd64
postgresql-9.4-partman/xenial-pgdg 3.1.3-1.pgdg16.04+1 amd64
postgresql-9.4-pgespresso/xenial-pgdg 1.2-3.pgdg16.04+1 amd64
postgresql-9.4-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-9.4-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-9.4-pglogical/xenial-pgdg 2.2.0-1.pgdg16.04+1 amd64
postgresql-9.4-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-9.4-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-9.4-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-9.4-pgq-node/xenial-pgdg,xenial-pgdg 3.2.5-1.pgdg16.04+1 all
postgresql-9.4-pgq3/xenial-pgdg 3.2.6-7.pgdg16.04+1 amd64
postgresql-9.4-pgrouting/xenial-pgdg 2.6.0-1.pgdg16.04+1 amd64
postgresql-9.4-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.4-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.4-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-9.4-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-9.4-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-9.4-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-9.4-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-9.4-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-9.4-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-9.4-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-9.4-postgis-2.2/xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 amd64
postgresql-9.4-postgis-2.2-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 all
postgresql-9.4-postgis-2.3/xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 amd64
postgresql-9.4-postgis-2.3-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.4-postgis-2.4/xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-9.4-postgis-2.4-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.4-postgis-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.4-powa/xenial-pgdg 3.1.1.pgdg16.04+1 amd64
postgresql-9.4-prefix/xenial-pgdg 1.2.7-1.pgdg16.04+1 amd64
postgresql-9.4-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-9.4-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-9.4-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.4-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.4-q3c/xenial-pgdg 1.5.0-2.pgdg16.04+1 amd64
postgresql-9.4-repack/xenial-pgdg 1.4.2-2.pgdg16.04+1 amd64
postgresql-9.4-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.4-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.4-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-9.4-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+2 amd64
postgresql-9.4-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.4-unit/xenial-pgdg 2.0.pgdg16.04+1 amd64
postgresql-9.4-wal2json/xenial-pgdg 1.0-2.pgdg16.04+1 amd64
postgresql-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-9.5-amcheck/xenial-pgdg 1.3-1.pgdg16.04+1 amd64
postgresql-9.5-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-9.5-bgw-replstatus/xenial-pgdg 1.0.2.pgdg16.04+1 amd64
postgresql-9.5-citus/xenial-pgdg 6.2.2.PGDG-1.pgdg16.04+1 amd64
postgresql-9.5-cron/xenial-pgdg 1.0.2-1.pgdg16.04+1 amd64
postgresql-9.5-dbg/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-9.5-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.5-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-9.5-hll/xenial-pgdg 2.10.2-1.pgdg16.04+1 amd64
postgresql-9.5-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-9.5-ip4r/xenial-pgdg 2.2-2.pgdg16.04+1 amd64
postgresql-9.5-jsquery/xenial-pgdg 1.0.1-1.pgdg16.04+1 amd64
postgresql-9.5-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-9.5-MysqL-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.5-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-9.5-orafce/xenial-pgdg 3.6.1-1.pgdg16.04+1 amd64
postgresql-9.5-partman/xenial-pgdg 3.1.3-1.pgdg16.04+1 amd64
postgresql-9.5-pgaudit/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-9.5-pgespresso/xenial-pgdg 1.2-3.pgdg16.04+1 amd64
postgresql-9.5-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-9.5-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-9.5-pgl-ddl-deploy/xenial-pgdg 1.3.0-1.pgdg16.04+1 amd64
postgresql-9.5-pglogical/xenial-pgdg 2.2.0-1.pgdg16.04+1 amd64
postgresql-9.5-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-9.5-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-9.5-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-9.5-pgq-node/xenial-pgdg,xenial-pgdg 3.2.5-1.pgdg16.04+1 all
postgresql-9.5-pgq3/xenial-pgdg 3.2.6-7.pgdg16.04+1 amd64
postgresql-9.5-pgrouting/xenial-pgdg 2.6.0-1.pgdg16.04+1 amd64
postgresql-9.5-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.5-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.5-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-9.5-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-9.5-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-9.5-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-9.5-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-9.5-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-9.5-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-9.5-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-9.5-postgis-2.2/xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 amd64
postgresql-9.5-postgis-2.2-scripts/xenial-pgdg,xenial-pgdg 2.2.2+dfsg-7~137.gite11228b.pgdg16.04+1 all
postgresql-9.5-postgis-2.3/xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 amd64
postgresql-9.5-postgis-2.3-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.5-postgis-2.4/xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-9.5-postgis-2.4-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.5-postgis-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.5-powa/xenial-pgdg 3.1.1.pgdg16.04+1 amd64
postgresql-9.5-prefix/xenial-pgdg 1.2.7-1.pgdg16.04+1 amd64
postgresql-9.5-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-9.5-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-9.5-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.5-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.5-q3c/xenial-pgdg 1.5.0-2.pgdg16.04+1 amd64
postgresql-9.5-repack/xenial-pgdg 1.4.2-2.pgdg16.04+1 amd64
postgresql-9.5-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.5-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.5-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-9.5-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+2 amd64
postgresql-9.5-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.5-unit/xenial-pgdg 6.0-1.pgdg16.04+1 amd64
postgresql-9.5-wal2json/xenial-pgdg 1.0-2.pgdg16.04+1 amd64
postgresql-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-9.6-amcheck/xenial-pgdg 1.3-1.pgdg16.04+1 amd64
postgresql-9.6-asn1oid/xenial-pgdg 1.2-1.pgdg16.04+1 amd64
postgresql-9.6-bgw-replstatus/xenial-pgdg 1.0.2.pgdg16.04+1 amd64
postgresql-9.6-citus/xenial-pgdg 7.3.0.PGDG-1.pgdg16.04+1 amd64
postgresql-9.6-cron/xenial-pgdg 1.0.2-1.pgdg16.04+1 amd64
postgresql-9.6-dbg/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-9.6-debversion/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.6-dirtyread/xenial-pgdg 1.3.pgdg16.04+1 amd64
postgresql-9.6-hll/xenial-pgdg 2.10.2-1.pgdg16.04+1 amd64
postgresql-9.6-hypopg/xenial-pgdg 1.1.1-1.pgdg16.04+1 amd64
postgresql-9.6-ip4r/xenial-pgdg 2.2-2.pgdg16.04+1 amd64
postgresql-9.6-jsquery/xenial-pgdg 1.0.1-1.pgdg16.04+1 amd64
postgresql-9.6-mimeo/xenial-pgdg,xenial-pgdg 1.5.1-2.pgdg16.04+1 all
postgresql-9.6-MysqL-fdw/xenial-pgdg 2.4.0-1.pgdg16.04+1 amd64
postgresql-9.6-ogr-fdw/xenial-pgdg 1.0.5-1.pgdg16.04+1 amd64
postgresql-9.6-orafce/xenial-pgdg 3.6.1-1.pgdg16.04+1 amd64
postgresql-9.6-partman/xenial-pgdg 3.1.3-1.pgdg16.04+1 amd64
postgresql-9.6-pgaudit/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-9.6-pgextwlist/xenial-pgdg 1.6-1.pgdg16.04+1 amd64
postgresql-9.6-pgfincore/xenial-pgdg 1.2.1-1.pgdg16.04+1 amd64
postgresql-9.6-pgl-ddl-deploy/xenial-pgdg 1.3.0-1.pgdg16.04+1 amd64
postgresql-9.6-pglogical/xenial-pgdg 2.2.0-1.pgdg16.04+1 amd64
postgresql-9.6-pgmemcache/xenial-pgdg 2.3.0-4.pgdg16.04+1 amd64
postgresql-9.6-pgmp/xenial-pgdg 1.0.2-5.pgdg16.04+1 amd64
postgresql-9.6-pgpool2/xenial-pgdg 3.7.2-1.pgdg16.04+1 amd64
postgresql-9.6-pgq-node/xenial-pgdg,xenial-pgdg 3.2.5-1.pgdg16.04+1 all
postgresql-9.6-pgq3/xenial-pgdg 3.2.6-7.pgdg16.04+1 amd64
postgresql-9.6-pgrouting/xenial-pgdg 2.6.0-1.pgdg16.04+1 amd64
postgresql-9.6-pgrouting-doc/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.6-pgrouting-scripts/xenial-pgdg,xenial-pgdg 2.6.0-1.pgdg16.04+1 all
postgresql-9.6-pgsphere/xenial-pgdg 1.1.1+2017.08.29-1.pgdg16.04+1 amd64
postgresql-9.6-pgtap/xenial-pgdg,xenial-pgdg 0.97.0-3.pgdg16.04+1 all
postgresql-9.6-pldebugger/xenial-pgdg 1:1.0-3-g71ac998-1.pgdg16.04+1 amd64
postgresql-9.6-pllua/xenial-pgdg 1:1.1.0-2.pgdg16.04+1 amd64
postgresql-9.6-plproxy/xenial-pgdg 2.8-1.pgdg16.04+1 amd64
postgresql-9.6-plr/xenial-pgdg 1:8.3.0.17-3.pgdg16.04+1 amd64
postgresql-9.6-plsh/xenial-pgdg 1.20171014-1.pgdg16.04+1 amd64
postgresql-9.6-plv8/xenial-pgdg 1:1.4.10.ds-1.pgdg16.04+1 amd64
postgresql-9.6-postgis-2.3/xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 amd64
postgresql-9.6-postgis-2.3-scripts/xenial-pgdg,xenial-pgdg 2.3.3+dfsg-1.pgdg16.04+1 all
postgresql-9.6-postgis-2.4/xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 amd64
postgresql-9.6-postgis-2.4-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.6-postgis-scripts/xenial-pgdg,xenial-pgdg 2.4.4+dfsg-1.pgdg16.04+1 all
postgresql-9.6-powa/xenial-pgdg 3.1.1.pgdg16.04+1 amd64
postgresql-9.6-prefix/xenial-pgdg 1.2.7-1.pgdg16.04+1 amd64
postgresql-9.6-preprepare/xenial-pgdg 0.9-1.pgdg16.04+1 amd64
postgresql-9.6-prioritize/xenial-pgdg 1.0.4-3.pgdg16.04+1 amd64
postgresql-9.6-python-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.6-python3-multicorn/xenial-pgdg 1.3.4-1.pgdg16.04+1 amd64
postgresql-9.6-q3c/xenial-pgdg 1.5.0-2.pgdg16.04+1 amd64
postgresql-9.6-repack/xenial-pgdg 1.4.2-2.pgdg16.04+1 amd64
postgresql-9.6-repmgr/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.6-repmgr-dbg/xenial-pgdg 4.0.5-1.pgdg16.04+1 amd64
postgresql-9.6-rum/xenial-pgdg 1.2.0-1.pgdg16.04+1 amd64
postgresql-9.6-similarity/xenial-pgdg 1.0-1.pgdg16.04+1 amd64
postgresql-9.6-slony1-2/xenial-pgdg 2.2.6-1.pgdg16.04+2 amd64
postgresql-9.6-toastinfo/xenial-pgdg 1.1-1.pgdg16.04+1 amd64
postgresql-9.6-unit/xenial-pgdg 6.0-1.pgdg16.04+1 amd64
postgresql-9.6-wal2json/xenial-pgdg 1.0-2.pgdg16.04+1 amd64
postgresql-all/xenial-pgdg,xenial-pgdg 10+191.pgdg16.04+1 all
postgresql-autodoc/xenial,xenial 1.40-3 all
postgresql-client/xenial-pgdg,xenial-pgdg 10+191.pgdg16.04+1 all
postgresql-client-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-client-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-client-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-client-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-client-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-client-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-client-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-client-common/xenial-pgdg,xenial-pgdg 191.pgdg16.04+1 all
postgresql-common/xenial-pgdg,xenial-pgdg 191.pgdg16.04+1 all
postgresql-comparator/xenial 2.2.6-2 amd64
postgresql-contrib/xenial-pgdg,xenial-pgdg 10+191.pgdg16.04+1 all
postgresql-contrib-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-contrib-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-contrib-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-contrib-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-contrib-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-contrib-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-doc/xenial-pgdg,xenial-pgdg 10+191.pgdg16.04+1 all
postgresql-doc-10/xenial-pgdg,xenial-pgdg 10.4-1.pgdg16.04+1 all
postgresql-doc-9.1/xenial-pgdg,xenial-pgdg 9.1.24-1.pgdg16.04+1 all
postgresql-doc-9.2/xenial-pgdg,xenial-pgdg 9.2.24-1.pgdg16.04+1 all
postgresql-doc-9.3/xenial-pgdg,xenial-pgdg 9.3.23-1.pgdg16.04+1 all
postgresql-doc-9.4/xenial-pgdg,xenial-pgdg 9.4.18-1.pgdg16.04+1 all
postgresql-doc-9.5/xenial-pgdg,xenial-pgdg 9.5.13-1.pgdg16.04+1 all
postgresql-doc-9.6/xenial-pgdg,xenial-pgdg 9.6.9-1.pgdg16.04+1 all
postgresql-filedump/xenial-pgdg 10.0-1.pgdg16.04+1 amd64
postgresql-hll/xenial 2.7-2.1 amd64
postgresql-MysqL-fdw-doc/xenial-pgdg,xenial-pgdg 2.2.0-2.pgdg16.04+1 all
postgresql-plperl-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-plperl-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-plperl-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-plperl-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-plperl-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-plperl-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-plperl-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-plpython-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-plpython-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-plpython-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-plpython-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-plpython-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-plpython-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-plpython-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-plpython3-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-plpython3-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-plpython3-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-plpython3-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-plpython3-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-plpython3-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-plpython3-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-pltcl-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-pltcl-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-pltcl-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-pltcl-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-pltcl-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-pltcl-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-pltcl-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-server-dev-10/xenial-pgdg 10.4-1.pgdg16.04+1 amd64
postgresql-server-dev-9.1/xenial-pgdg 9.1.24-1.pgdg16.04+1 amd64
postgresql-server-dev-9.2/xenial-pgdg 9.2.24-1.pgdg16.04+1 amd64
postgresql-server-dev-9.3/xenial-pgdg 9.3.23-1.pgdg16.04+1 amd64
postgresql-server-dev-9.4/xenial-pgdg 9.4.18-1.pgdg16.04+1 amd64
postgresql-server-dev-9.5/xenial-pgdg 9.5.13-1.pgdg16.04+1 amd64
postgresql-server-dev-9.6/xenial-pgdg 9.6.9-1.pgdg16.04+1 amd64
postgresql-server-dev-all/xenial-pgdg,xenial-pgdg 191.pgdg16.04+1 all
puppet-module-puppetlabs-postgresql/xenial,xenial 4.6.1-1 all
pure-ftpd-postgresql/xenial 1.0.36-3.2build1 amd64
python3-postgresql/xenial 1.1.0-2build2 amd64
r-cran-rpostgresql/xenial 0.4-1 amd64
rt4-db-postgresql/xenial,xenial 4.2.12-5 all
sisu-postgresql/xenial,xenial 7.1.7-1 all
tarantool-lts-postgresql-module/xenial 1.5.5-18-g2998d20-1ubuntu1 amd64
tntdb-postgresql4v5/xenial 1.3-3build1 amd64
lwk@qwfys ~ $
查找pgadmin4安装包
lwk@qwfys ~ $ apt list |grep pgadmin
WARNING: apt does not have a stable CLI interface. Use with caution in scripts.
pgadmin3/xenial-pgdg 1.22.2-4.pgdg16.04+1 amd64
pgadmin3-data/xenial-pgdg,xenial-pgdg 1.22.2-4.pgdg16.04+1 all
pgadmin3-dbg/xenial-pgdg 1.22.2-4.pgdg16.04+1 amd64
pgadmin4/xenial-pgdg 3.0-2.pgdg16.04+1 amd64
pgadmin4-apache2/xenial-pgdg,xenial-pgdg 3.0-2.pgdg16.04+1 all
pgadmin4-common/xenial-pgdg,xenial-pgdg 3.0-2.pgdg16.04+1 all
pgadmin4-doc/xenial-pgdg,xenial-pgdg 3.0-2.pgdg16.04+1 all
PHPpgadmin/xenial,xenial 5.1+ds-1ubuntu1 all
lwk@qwfys ~ $
安装postgresql 10与pgadmin4
lwk@qwfys ~ $ apt install postgresql-10 pgadmin4 -y
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
alembic fonts-font-awesome libjs-jquery libjs-sphinxdoc libjs-underscore pgadmin4-common pgdg-keyring postgresql-client-10 postgresql-client-common postgresql-common python-alembic python-babel-localedata python-sqlalchemy
python3-alembic python3-babel python3-dateutil python3-flask python3-flask-babelex python3-flask-gravatar python3-flask-htmlmin python3-flask-login python3-flask-mail python3-flask-migrate python3-flask-paranoid
python3-flask-principal python3-flask-script python3-flask-security python3-flask-sqlalchemy python3-flaskext.wtf python3-htmlmin python3-itsdangerous python3-jinja2 python3-passlib python3-psycopg2 python3-simplejson
python3-sqlalchemy python3-sqlparse python3-tz python3-werkzeug python3-wtforms
Suggested packages:
javascript-common pgadmin4-doc locales-all postgresql-doc-10 libjson-perl python-editor python-sqlalchemy-doc python-psycopg2 python-pyMysqL python-fdb python-pymssql python3-editor python-flask-doc python3-flask-login-doc
python-jinja2-doc python-psycopg2-doc python3-pyMysqL python3-fdb python-sqlparse-doc ipython3 python-werkzeug-doc python3-django python3-django-localflavor
Recommended packages:
javascript-common sysstat python-sqlalchemy-ext python3-openssl python3-pyinotify
The following NEW packages will be installed:
alembic fonts-font-awesome libjs-jquery libjs-sphinxdoc libjs-underscore pgadmin4 pgadmin4-common pgdg-keyring postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common python-alembic python-babel-localedata
python-sqlalchemy python3-alembic python3-babel python3-dateutil python3-flask python3-flask-babelex python3-flask-gravatar python3-flask-htmlmin python3-flask-login python3-flask-mail python3-flask-migrate python3-flask-paranoid
python3-flask-principal python3-flask-script python3-flask-security python3-flask-sqlalchemy python3-flaskext.wtf python3-htmlmin python3-itsdangerous python3-jinja2 python3-passlib python3-psycopg2 python3-simplejson
python3-sqlalchemy python3-sqlparse python3-tz python3-werkzeug python3-wtforms
0 upgraded,42 newly installed,0 to remove and 0 not upgraded.
Need to get 16.1 MB of archives.
After this operation,85.5 MB of additional disk space will be used.
Get:1 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python-sqlalchemy all 1.0.11+ds1-1ubuntu2 [636 kB]
Get:2 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-babelex all 0.9.3-1~pgdg16.04+1 [9,118 B]
Get:3 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-gravatar all 0.4.2-1~pgdg16.04+1 [5,448 B]
Get:4 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-htmlmin all 0.1.12-1.pgdg16.04+1 [18.6 kB]
Get:5 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-htmlmin all 1.3.2-1~pgdg16.04+1 [4,012 B]
Get:6 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-login all 0.4.0-1~pgdg16.04+1 [15.4 kB]
Get:7 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-paranoid all 0.2.0-2~pgdg16.04+1 [4,874 B]
Get:8 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-mail all 0.9.1+dfsg1-1~pgdg16.04+1 [14.1 kB]
Get:9 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flaskext.wtf all 0.14.2-2~pgdg16.04+1 [12.4 kB]
Get:10 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-flask-security all 1.7.5-2~pgdg16.04+1 [22.4 kB]
Get:11 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 python3-psycopg2 amd64 2.7.4-1.pgdg16.04+1 [175 kB]
Get:12 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 pgadmin4-common all 3.0-2.pgdg16.04+1 [3,798 kB]
Get:13 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python-alembic all 0.8.2-3ubuntu1 [97.9 kB]
Get:14 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-sqlalchemy all 1.0.11+ds1-1ubuntu2 [635 kB]
Get:15 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-alembic all 0.8.2-3ubuntu1 [98.0 kB]
Get:16 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 libjs-jquery all 1.11.3+dfsg-4 [161 kB]
Get:17 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 libjs-underscore all 1.7.0~dfsg-1ubuntu1 [46.7 kB]
Get:18 http://mirrors.ustc.edu.cn/ubuntu xenial-updates/main amd64 libjs-sphinxdoc all 1.3.6-2ubuntu1.1 [57.6 kB]
Get:19 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 alembic all 0.8.2-3ubuntu1 [224 kB]
Get:20 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 fonts-font-awesome all 4.5.0~dfsg-1 [506 kB]
Get:21 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-dateutil all 2.4.2-1 [39.1 kB]
Get:22 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-itsdangerous all 0.24+dfsg1-1 [11.8 kB]
Get:23 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-jinja2 all 2.8-1 [103 kB]
Get:24 http://mirrors.ustc.edu.cn/ubuntu xenial-updates/universe amd64 python3-werkzeug all 0.10.4+dfsg1-1ubuntu1.1 [162 kB]
Get:25 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-flask all 0.10.1-2build2 [51.8 kB]
Get:26 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python-babel-localedata all 1.3+dfsg.1-6 [1,931 kB]
Get:27 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-tz all 2014.10~dfsg1-0ubuntu2 [24.6 kB]
Get:28 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-babel all 1.3+dfsg.1-6 [67.5 kB]
Get:29 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-flask-script all 0.6.7-1build1 [12.5 kB]
Get:30 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-flask-sqlalchemy all 1.0-3 [12.5 kB]
Get:31 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-flask-migrate all 1.7.0-1 [8,834 B]
Get:32 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-flask-principal all 0.4.0-1build1 [7,586 B]
Get:33 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-wtforms all 2.1-1 [61.3 kB]
Get:34 http://mirrors.ustc.edu.cn/ubuntu xenial/universe amd64 python3-passlib all 1.6.5-4 [219 kB]
Get:35 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-simplejson amd64 3.8.1-1ubuntu2 [48.6 kB]
Get:36 http://mirrors.ustc.edu.cn/ubuntu xenial/main amd64 python3-sqlparse all 0.1.18-1 [28.0 kB]
Get:37 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 pgadmin4 amd64 3.0-2.pgdg16.04+1 [257 kB]
Get:38 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 pgdg-keyring all 2017.3 [10.3 kB]
Get:39 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 postgresql-client-common all 191.pgdg16.04+1 [82.3 kB]
Get:40 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 postgresql-client-10 amd64 10.4-1.pgdg16.04+1 [1,328 kB]
Get:41 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 postgresql-common all 191.pgdg16.04+1 [222 kB]
Get:42 http://apt.postgresql.org/pub/repos/apt xenial-pgdg/main amd64 postgresql-10 amd64 10.4-1.pgdg16.04+1 [4,893 kB]
Fetched 16.1 MB in 30s (537 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting prevIoUsly unselected package python-sqlalchemy.
(Reading database ... 257718 files and directories currently installed.)
Preparing to unpack .../python-sqlalchemy_1.0.11+ds1-1ubuntu2_all.deb ...
Unpacking python-sqlalchemy (1.0.11+ds1-1ubuntu2) ...
Selecting prevIoUsly unselected package python-alembic.
Preparing to unpack .../python-alembic_0.8.2-3ubuntu1_all.deb ...
Unpacking python-alembic (0.8.2-3ubuntu1) ...
Selecting prevIoUsly unselected package python3-sqlalchemy.
Preparing to unpack .../python3-sqlalchemy_1.0.11+ds1-1ubuntu2_all.deb ...
Unpacking python3-sqlalchemy (1.0.11+ds1-1ubuntu2) ...
Selecting prevIoUsly unselected package python3-alembic.
Preparing to unpack .../python3-alembic_0.8.2-3ubuntu1_all.deb ...
Unpacking python3-alembic (0.8.2-3ubuntu1) ...
Selecting prevIoUsly unselected package libjs-jquery.
Preparing to unpack .../libjs-jquery_1.11.3+dfsg-4_all.deb ...
Unpacking libjs-jquery (1.11.3+dfsg-4) ...
Selecting prevIoUsly unselected package libjs-underscore.
Preparing to unpack .../libjs-underscore_1.7.0~dfsg-1ubuntu1_all.deb ...
Unpacking libjs-underscore (1.7.0~dfsg-1ubuntu1) ...
Selecting prevIoUsly unselected package libjs-sphinxdoc.
Preparing to unpack .../libjs-sphinxdoc_1.3.6-2ubuntu1.1_all.deb ...
Unpacking libjs-sphinxdoc (1.3.6-2ubuntu1.1) ...
Selecting prevIoUsly unselected package alembic.
Preparing to unpack .../alembic_0.8.2-3ubuntu1_all.deb ...
Unpacking alembic (0.8.2-3ubuntu1) ...
Selecting prevIoUsly unselected package fonts-font-awesome.
Preparing to unpack .../fonts-font-awesome_4.5.0~dfsg-1_all.deb ...
Unpacking fonts-font-awesome (4.5.0~dfsg-1) ...
Selecting prevIoUsly unselected package python3-dateutil.
Preparing to unpack .../python3-dateutil_2.4.2-1_all.deb ...
Unpacking python3-dateutil (2.4.2-1) ...
Selecting prevIoUsly unselected package python3-itsdangerous.
Preparing to unpack .../python3-itsdangerous_0.24+dfsg1-1_all.deb ...
Unpacking python3-itsdangerous (0.24+dfsg1-1) ...
Selecting prevIoUsly unselected package python3-jinja2.
Preparing to unpack .../python3-jinja2_2.8-1_all.deb ...
Unpacking python3-jinja2 (2.8-1) ...
Selecting prevIoUsly unselected package python3-werkzeug.
Preparing to unpack .../python3-werkzeug_0.10.4+dfsg1-1ubuntu1.1_all.deb ...
Unpacking python3-werkzeug (0.10.4+dfsg1-1ubuntu1.1) ...
Selecting prevIoUsly unselected package python3-flask.
Preparing to unpack .../python3-flask_0.10.1-2build2_all.deb ...
Unpacking python3-flask (0.10.1-2build2) ...
Selecting prevIoUsly unselected package python-babel-localedata.
Preparing to unpack .../python-babel-localedata_1.3+dfsg.1-6_all.deb ...
Unpacking python-babel-localedata (1.3+dfsg.1-6) ...
Selecting prevIoUsly unselected package python3-tz.
Preparing to unpack .../python3-tz_2014.10~dfsg1-0ubuntu2_all.deb ...
Unpacking python3-tz (2014.10~dfsg1-0ubuntu2) ...
Selecting prevIoUsly unselected package python3-babel.
Preparing to unpack .../python3-babel_1.3+dfsg.1-6_all.deb ...
Unpacking python3-babel (1.3+dfsg.1-6) ...
Selecting prevIoUsly unselected package python3-flask-babelex.
Preparing to unpack .../python3-flask-babelex_0.9.3-1~pgdg16.04+1_all.deb ...
Unpacking python3-flask-babelex (0.9.3-1~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-gravatar.
Preparing to unpack .../python3-flask-gravatar_0.4.2-1~pgdg16.04+1_all.deb ...
Unpacking python3-flask-gravatar (0.4.2-1~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-htmlmin.
Preparing to unpack .../python3-htmlmin_0.1.12-1.pgdg16.04+1_all.deb ...
Unpacking python3-htmlmin (0.1.12-1.pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-htmlmin.
Preparing to unpack .../python3-flask-htmlmin_1.3.2-1~pgdg16.04+1_all.deb ...
Unpacking python3-flask-htmlmin (1.3.2-1~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-login.
Preparing to unpack .../python3-flask-login_0.4.0-1~pgdg16.04+1_all.deb ...
Unpacking python3-flask-login (0.4.0-1~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-script.
Preparing to unpack .../python3-flask-script_0.6.7-1build1_all.deb ...
Unpacking python3-flask-script (0.6.7-1build1) ...
Selecting prevIoUsly unselected package python3-flask-sqlalchemy.
Preparing to unpack .../python3-flask-sqlalchemy_1.0-3_all.deb ...
Unpacking python3-flask-sqlalchemy (1.0-3) ...
Selecting prevIoUsly unselected package python3-flask-migrate.
Preparing to unpack .../python3-flask-migrate_1.7.0-1_all.deb ...
Unpacking python3-flask-migrate (1.7.0-1) ...
Selecting prevIoUsly unselected package python3-flask-paranoid.
Preparing to unpack .../python3-flask-paranoid_0.2.0-2~pgdg16.04+1_all.deb ...
Unpacking python3-flask-paranoid (0.2.0-2~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-mail.
Preparing to unpack .../python3-flask-mail_0.9.1+dfsg1-1~pgdg16.04+1_all.deb ...
Unpacking python3-flask-mail (0.9.1+dfsg1-1~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-flask-principal.
Preparing to unpack .../python3-flask-principal_0.4.0-1build1_all.deb ...
Unpacking python3-flask-principal (0.4.0-1build1) ...
Selecting prevIoUsly unselected package python3-wtforms.
Preparing to unpack .../python3-wtforms_2.1-1_all.deb ...
Unpacking python3-wtforms (2.1-1) ...
Selecting prevIoUsly unselected package python3-flaskext.wtf.
Preparing to unpack .../python3-flaskext.wtf_0.14.2-2~pgdg16.04+1_all.deb ...
Unpacking python3-flaskext.wtf (0.14.2-2~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-passlib.
Preparing to unpack .../python3-passlib_1.6.5-4_all.deb ...
Unpacking python3-passlib (1.6.5-4) ...
Selecting prevIoUsly unselected package python3-flask-security.
Preparing to unpack .../python3-flask-security_1.7.5-2~pgdg16.04+1_all.deb ...
Unpacking python3-flask-security (1.7.5-2~pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-psycopg2.
Preparing to unpack .../python3-psycopg2_2.7.4-1.pgdg16.04+1_amd64.deb ...
Unpacking python3-psycopg2 (2.7.4-1.pgdg16.04+1) ...
Selecting prevIoUsly unselected package python3-simplejson.
Preparing to unpack .../python3-simplejson_3.8.1-1ubuntu2_amd64.deb ...
Unpacking python3-simplejson (3.8.1-1ubuntu2) ...
Selecting prevIoUsly unselected package python3-sqlparse.
Preparing to unpack .../python3-sqlparse_0.1.18-1_all.deb ...
Unpacking python3-sqlparse (0.1.18-1) ...
Selecting prevIoUsly unselected package pgadmin4-common.
Preparing to unpack .../pgadmin4-common_3.0-2.pgdg16.04+1_all.deb ...
Unpacking pgadmin4-common (3.0-2.pgdg16.04+1) ...
Selecting prevIoUsly unselected package pgadmin4.
Preparing to unpack .../pgadmin4_3.0-2.pgdg16.04+1_amd64.deb ...
Unpacking pgadmin4 (3.0-2.pgdg16.04+1) ...
Selecting prevIoUsly unselected package pgdg-keyring.
Preparing to unpack .../pgdg-keyring_2017.3_all.deb ...
Unpacking pgdg-keyring (2017.3) ...
Selecting prevIoUsly unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_191.pgdg16.04+1_all.deb ...
Unpacking postgresql-client-common (191.pgdg16.04+1) ...
Selecting prevIoUsly unselected package postgresql-client-10.
Preparing to unpack .../postgresql-client-10_10.4-1.pgdg16.04+1_amd64.deb ...
Unpacking postgresql-client-10 (10.4-1.pgdg16.04+1) ...
Selecting prevIoUsly unselected package postgresql-common.
Preparing to unpack .../postgresql-common_191.pgdg16.04+1_all.deb ...
Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common'
Unpacking postgresql-common (191.pgdg16.04+1) ...
Selecting prevIoUsly unselected package postgresql-10.
Preparing to unpack .../postgresql-10_10.4-1.pgdg16.04+1_amd64.deb ...
Unpacking postgresql-10 (10.4-1.pgdg16.04+1) ...
Processing triggers for doc-base (0.10.7) ...
Processing 1 added doc-base file...
Registering documents with scrollkeeper...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for fontconfig (2.11.94-0ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
Processing triggers for desktop-file-utils (0.22+linuxmint1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Processing triggers for systemd (229-4ubuntu21.2) ...
Processing triggers for ureadahead (0.100.0-19) ...
Setting up python-sqlalchemy (1.0.11+ds1-1ubuntu2) ...
Setting up python-alembic (0.8.2-3ubuntu1) ...
update-alternatives: using /usr/bin/python2-alembic to provide /usr/bin/alembic (alembic) in auto mode
Setting up python3-sqlalchemy (1.0.11+ds1-1ubuntu2) ...
Setting up python3-alembic (0.8.2-3ubuntu1) ...
Setting up libjs-jquery (1.11.3+dfsg-4) ...
Setting up libjs-underscore (1.7.0~dfsg-1ubuntu1) ...
Setting up libjs-sphinxdoc (1.3.6-2ubuntu1.1) ...
Setting up alembic (0.8.2-3ubuntu1) ...
Setting up fonts-font-awesome (4.5.0~dfsg-1) ...
Setting up python3-dateutil (2.4.2-1) ...
Setting up python3-itsdangerous (0.24+dfsg1-1) ...
Setting up python3-jinja2 (2.8-1) ...
Setting up python3-werkzeug (0.10.4+dfsg1-1ubuntu1.1) ...
Setting up python3-flask (0.10.1-2build2) ...
Setting up python-babel-localedata (1.3+dfsg.1-6) ...
Setting up python3-tz (2014.10~dfsg1-0ubuntu2) ...
Setting up python3-babel (1.3+dfsg.1-6) ...
update-alternatives: using /usr/bin/pybabel-python3 to provide /usr/bin/pybabel (pybabel) in auto mode
Setting up python3-flask-babelex (0.9.3-1~pgdg16.04+1) ...
Setting up python3-flask-gravatar (0.4.2-1~pgdg16.04+1) ...
Setting up python3-htmlmin (0.1.12-1.pgdg16.04+1) ...
Setting up python3-flask-htmlmin (1.3.2-1~pgdg16.04+1) ...
Setting up python3-flask-login (0.4.0-1~pgdg16.04+1) ...
Setting up python3-flask-script (0.6.7-1build1) ...
Setting up python3-flask-sqlalchemy (1.0-3) ...
Setting up python3-flask-migrate (1.7.0-1) ...
Setting up python3-flask-paranoid (0.2.0-2~pgdg16.04+1) ...
Setting up python3-flask-mail (0.9.1+dfsg1-1~pgdg16.04+1) ...
Setting up python3-flask-principal (0.4.0-1build1) ...
Setting up python3-wtforms (2.1-1) ...
Setting up python3-flaskext.wtf (0.14.2-2~pgdg16.04+1) ...
Setting up python3-passlib (1.6.5-4) ...
Setting up python3-flask-security (1.7.5-2~pgdg16.04+1) ...
Setting up python3-psycopg2 (2.7.4-1.pgdg16.04+1) ...
Setting up python3-simplejson (3.8.1-1ubuntu2) ...
Setting up python3-sqlparse (0.1.18-1) ...
Setting up pgadmin4-common (3.0-2.pgdg16.04+1) ...
Setting up pgadmin4 (3.0-2.pgdg16.04+1) ...
Setting up pgdg-keyring (2017.3) ...
Removing apt.postgresql.org key from trusted.gpg: OK
Setting up postgresql-client-common (191.pgdg16.04+1) ...
Setting up postgresql-client-10 (10.4-1.pgdg16.04+1) ...
update-alternatives: using /usr/share/postgresql/10/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-common (191.pgdg16.04+1) ...
Adding user postgres to group ssl-cert
Creating config file /etc/postgresql-common/createcluster.conf with new version
Building Postgresql dictionaries from installed myspell/hunspell packages...
de_at
de_ch
de_de
en_au
en_ca
en_gb
en_us
en_za
es
fr
it_it
pt
pt_br
ERROR: no ecoding defined in /usr/share/hunspell/ru_RU.aff,ignoring
Removing obsolete dictionary files:
Setting up postgresql-10 (10.4-1.pgdg16.04+1) ...
Creating new Postgresql cluster 10/main ...
/usr/lib/postgresql/10/bin/initdb -D /var/lib/postgresql/10/main --auth-local peer --auth-host md5
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locales
COLLATE: en_US.UTF-8
CTYPE: en_US.UTF-8
MESSAGES: en_US.UTF-8
MONETARY: zh_CN.UTF-8
NUMERIC: zh_CN.UTF-8
TIME: en_US.UTF-8
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /var/lib/postgresql/10/main ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
Success. You can now start the database server using:
/usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/main -l logfile start
Ver Cluster Port Status Owner Data directory Log file
10 main 5432 down postgres /var/lib/postgresql/10/main /var/log/postgresql/postgresql-10-main.log
update-alternatives: using /usr/share/postgresql/10/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
Processing triggers for systemd (229-4ubuntu21.2) ...
Processing triggers for ureadahead (0.100.0-19) ...
lwk@qwfys ~ $
配置
账号设置
Postgresql 10安装成功以后，通常情况下需要能进行远程管理，因为这里我们配置一下，使其能从远程访问。另外，Postgresql10安装成功以后，系统默认创建了一个名为postgres操作系统用户作为数据库用户，但是该用户密码为空，即没有设置，这里我们也要给该用户设置一个密码。
我们将通过以下命令设置Postgresql 10的数据库用户postgres的用户密码：
lwk@qwfys ~ $ sudo -u postgres psql
[sudo] password for lwk:
psql (10.4 (Ubuntu 10.4-1.pgdg16.04+1))
Type "help" for help.
postgres=#
postgres=# alter user postgres with password 'postgres';
ALTER ROLE
postgres=# \q
lwk@qwfys ~ $
接着，我们将通过以下命令对数据库用户postgres对应的操作系统用户设置密码：
lwk@qwfys ~ $ sudo passwd postgres
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
lwk@qwfys ~
密码设置完成。
远程访问设置
postgresql10配置文件在目录/etc/postgresql/10/main/中，内容如下：
lwk@qwfys ~ $ ll /etc/postgresql/10/main/
total 60
drwxr-xr-x 3 postgres postgres 4096 May 15 05:00 ./
drwxr-xr-x 3 postgres postgres 4096 May 15 04:22 ../
drwxr-xr-x 2 postgres postgres 4096 May 15 04:22 conf.d/
-rw-r--r-- 1 postgres postgres 315 May 15 04:22 environment
-rw-r--r-- 1 postgres postgres 143 May 15 04:22 pg_ctl.conf
-rw-r----- 1 postgres postgres 4686 May 15 04:22 pg_hba.conf
-rw-r----- 1 postgres postgres 1636 May 15 04:22 pg_ident.conf
-rw-r--r-- 1 postgres postgres 23001 May 15 04:59 postgresql.conf
-rw-r--r-- 1 postgres postgres 317 May 15 04:22 start.conf
lwk@qwfys ~
远程访问将涉及postgresql.conf和pg_hba.conf两个文件，文件postgresql.conf内容如下：
lwk@qwfys ~ $ cat /etc/postgresql/10/main/postgresql.conf
# -----------------------------
# Postgresql configuration file
# -----------------------------
#
# This file consists of lines of the form:
#
# name = value
#
# (The "=" is optional.) Whitespace may be used. Comments are introduced with
# "#" anywhere on a line. The complete list of parameter names and allowed
# values can be found in the Postgresql documentation.
#
# The commented-out settings shown in this file represent the default values.
# Re-commenting a setting is NOT sufficient to revert it to the default value;
# you need to reload the server.
#
# This file is read on server startup and when the server receives a SIGHUP
# signal. If you edit the file on a running system,you have to SIGHUP the
# server for the changes to take effect,run "pg_ctl reload",or execute
# "SELECT pg_reload_conf()". Some parameters,which are marked below,
# require a server shutdown and restart to take effect.
#
# Any parameter can also be given as a command-line option to the server,e.g.,
# "postgres -c log_connections=on". Some parameters can be changed at run time
# with the "SET" sql command.
#
# Memory units: kB = kilobytes Time units: ms = milliseconds
# MB = megabytes s = seconds
# GB = gigabytes min = minutes
# TB = terabytes h = hours
# d = days
#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------
# The default values of these variables are driven from the -D command-line
# option or PGDATA environment variable,represented here as ConfigDir.
data_directory = '/var/lib/postgresql/10/main' # use data in another directory
# (change requires restart)
hba_file = '/etc/postgresql/10/main/pg_hba.conf' # host-based authentication file
# (change requires restart)
ident_file = '/etc/postgresql/10/main/pg_ident.conf' # ident configuration file
# (change requires restart)
# If external_pid_file is not explicitly set,no extra PID file is written.
external_pid_file = '/var/run/postgresql/10-main.pid' # write an extra PID file
# (change requires restart)
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
#listen_addresses = 'localhost' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
#superuser_reserved_connections = 3 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
# (change requires restart)
#unix_socket_group = '' # (change requires restart)
#unix_socket_permissions = 0777 # begin with 0 to use octal notation
# (change requires restart)
#bonjour = off # advertise server via Bonjour
# (change requires restart)
#bonjour_name = '' # defaults to the computer name
# (change requires restart)
# - Security and Authentication -
#authentication_timeout = 1min # 1s-600s
ssl = on
#ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
#ssl_prefer_server_ciphers = on
#ssl_ecdh_curve = 'prime256v1'
#ssl_dh_params_file = ''
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
#ssl_ca_file = ''
#ssl_crl_file = ''
#password_encryption = md5 # md5 or scram-sha-256
#db_user_namespace = off
#row_security = on
# GSSAPI using Kerberos
#krb_server_keyfile = ''
#krb_caseins_users = off
# - TCP Keepalives -
# see "man 7 tcp" for details
#tcp_keepalives_idle = 0 # TCP_KEEPIDLE,in seconds;
# 0 selects the system default
#tcp_keepalives_interval = 0 # TCP_KEEPINTVL,in seconds;
# 0 selects the system default
#tcp_keepalives_count = 0 # TCP_KEEPCNT;
# 0 selects the system default
#------------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------
# - Memory -
shared_buffers = 128MB # min 128kB
# (change requires restart)
#huge_pages = try # on,off,or try
# (change requires restart)
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
# (change requires restart)
# Caution: it is not advisable to set max_prepared_transactions nonzero unless
# you actively intend to use prepared transactions.
#work_mem = 4MB # min 64kB
#maintenance_work_mem = 64MB # min 1MB
#replacement_sort_tuples = 150000 # limits use of replacement selection sort
#autovacuum_work_mem = -1 # min 1MB,or -1 to use maintenance_work_mem
#max_stack_depth = 2MB # min 100kB
dynamic_shared_memory_type = posix # the default is the first option
# supported by the operating system:
# posix
# sysv
# windows
# mmap
# use none to disable dynamic shared memory
# (change requires restart)
# - Disk -
#temp_file_limit = -1 # limits per-process temp file space
# in kB,or -1 for no limit
# - Kernel Resource Usage -
#max_files_per_process = 1000 # min 25
# (change requires restart)
#shared_preload_libraries = '' # (change requires restart)
# - Cost-Based Vacuum Delay -
#vacuum_cost_delay = 0 # 0-100 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 1-10000 credits
# - Background Writer -
#bgwriter_delay = 200ms # 10-10000ms between rounds
#bgwriter_lru_maxpages = 100 # 0-1000 max buffers written/round
#bgwriter_lru_multiplier = 2.0 # 0-10.0 multiplier on buffers scanned/round
#bgwriter_flush_after = 512kB # measured in pages,0 disables
# - Asynchronous Behavior -
#effective_io_concurrency = 1 # 1-1000; 0 disables prefetching
#max_worker_processes = 8 # (change requires restart)
#max_parallel_workers_per_gather = 2 # taken from max_parallel_workers
#max_parallel_workers = 8 # maximum number of max_worker_processes that
# can be used in parallel queries
#old_snapshot_threshold = -1 # 1min-60d; -1 disables; 0 is immediate
# (change requires restart)
#backend_flush_after = 0 # measured in pages,0 disables
#------------------------------------------------------------------------------
# WRITE AHEAD LOG
#------------------------------------------------------------------------------
# - Settings -
#wal_level = replica # minimal,replica,or logical
# (change requires restart)
#fsync = on # flush data to disk for crash safety
# (turning this off can cause
# unrecoverable data corruption)
#synchronous_commit = on # synchronization level;
# off,local,remote_write,remote_apply,or on
#wal_sync_method = fsync # the default is the first option
# supported by the operating system:
# open_datasync
# fdatasync (default on Linux)
# fsync
# fsync_writethrough
# open_sync
#full_page_writes = on # recover from partial page writes
#wal_compression = off # enable compression of full-page writes
#wal_log_hints = off # also do full page writes of non-critical updates
# (change requires restart)
#wal_buffers = -1 # min 32kB,-1 sets based on shared_buffers
# (change requires restart)
#wal_writer_delay = 200ms # 1-10000 milliseconds
#wal_writer_flush_after = 1MB # measured in pages,0 disables
#commit_delay = 0 # range 0-100000,in microseconds
#commit_siblings = 5 # range 1-1000
# - Checkpoints -
#checkpoint_timeout = 5min # range 30s-1d
#max_wal_size = 1GB
#min_wal_size = 80MB
#checkpoint_completion_target = 0.5 # checkpoint target duration,0.0 - 1.0
#checkpoint_flush_after = 256kB # measured in pages,0 disables
#checkpoint_warning = 30s # 0 disables
# - Archiving -
#archive_mode = off # enables archiving; off,on,or always
# (change requires restart)
#archive_command = '' # command to use to archive a logfile segment
# placeholders: %p = path of file to archive
# %f = file name only
# e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f'
#archive_timeout = 0 # force a logfile segment switch after this
# number of seconds; 0 disables
#------------------------------------------------------------------------------
# REPLICATION
#------------------------------------------------------------------------------
# - Sending Server(s) -
# Set these on the master and on any standby that will send replication data.
#max_wal_senders = 10 # max number of walsender processes
# (change requires restart)
#wal_keep_segments = 0 # in logfile segments,16MB each; 0 disables
#wal_sender_timeout = 60s # in milliseconds; 0 disables
#max_replication_slots = 10 # max number of replication slots
# (change requires restart)
#track_commit_timestamp = off # collect timestamp of transaction commit
# (change requires restart)
# - Master Server -
# These settings are ignored on a standby server.
#synchronous_standby_names = '' # standby servers that provide sync rep
# method to choose sync standbys,number of sync standbys,# and comma-separated list of application_name
# from standby(s); '*' = all
#vacuum_defer_cleanup_age = 0 # number of xacts by which cleanup is delayed
# - Standby Servers -
# These settings are ignored on a master server.
#hot_standby = on # "off" disallows queries during recovery
# (change requires restart)
#max_standby_archive_delay = 30s # max delay before canceling queries
# when reading WAL from archive;
# -1 allows indefinite delay
#max_standby_streaming_delay = 30s # max delay before canceling queries
# when reading streaming WAL;
# -1 allows indefinite delay
#wal_receiver_status_interval = 10s # send replies at least this often
# 0 disables
#hot_standby_Feedback = off # send info from standby to prevent
# query conflicts
#wal_receiver_timeout = 60s # time that receiver waits for
# communication from master
# in milliseconds; 0 disables
#wal_retrieve_retry_interval = 5s # time to wait before retrying to
# retrieve WAL after a Failed attempt
# - Subscribers -
# These settings are ignored on a publisher.
#max_logical_replication_workers = 4 # taken from max_worker_processes
# (change requires restart)
#max_sync_workers_per_subscription = 2 # taken from max_logical_replication_workers
#------------------------------------------------------------------------------
# QUERY TUNING
#------------------------------------------------------------------------------
# - Planner Method Configuration -
#enable_bitmapscan = on
#enable_hashagg = on
#enable_hashjoin = on
#enable_indexscan = on
#enable_indexonlyscan = on
#enable_material = on
#enable_mergejoin = on
#enable_nestloop = on
#enable_seqscan = on
#enable_sort = on
#enable_tidscan = on
# - Planner Cost Constants -
#seq_page_cost = 1.0 # measured on an arbitrary scale
#random_page_cost = 4.0 # same scale as above
#cpu_tuple_cost = 0.01 # same scale as above
#cpu_index_tuple_cost = 0.005 # same scale as above
#cpu_operator_cost = 0.0025 # same scale as above
#parallel_tuple_cost = 0.1 # same scale as above
#parallel_setup_cost = 1000.0 # same scale as above
#min_parallel_table_scan_size = 8MB
#min_parallel_index_scan_size = 512kB
#effective_cache_size = 4GB
# - Genetic Query Optimizer -
#geqo = on
#geqo_threshold = 12
#geqo_effort = 5 # range 1-10
#geqo_pool_size = 0 # selects default based on effort
#geqo_generations = 0 # selects default based on effort
#geqo_selection_bias = 2.0 # range 1.5-2.0
#geqo_seed = 0.0 # range 0.0-1.0
# - Other Planner Options -
#default_statistics_target = 100 # range 1-10000
#constraint_exclusion = partition # on,or partition
#cursor_tuple_fraction = 0.1 # range 0.0-1.0
#from_collapse_limit = 8
#join_collapse_limit = 8 # 1 disables collapsing of explicit
# JOIN clauses
#force_parallel_mode = off
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
#log_destination = 'stderr' # Valid values are combinations of
# stderr,csvlog,syslog,and eventlog,# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
#logging_collector = off # Enable capturing of stderr and csvlog
# into log files. required to be on for
# csvlogs.
# (change requires restart)
# These are only used if logging_collector is on:
#log_directory = 'log' # directory where log files are written,
# can be absolute or relative to PGDATA
#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # log file name pattern,
# can include strftime() escapes
#log_file_mode = 0600 # creation mode for log files,
# begin with 0 to use octal notation
#log_truncate_on_rotation = off # If on,an existing log file with the
# same name as the new log file will be
# truncated rather than appended to.
# But such truncation only occurs on
# time-driven rotation,not on restarts
# or size-driven rotation. Default is
# off,meaning append to existing files
# in all cases.
#log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 disables.
#log_rotation_size = 10MB # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
#syslog_sequence_numbers = on
#syslog_split_messages = on
# This is only relevant when logging to eventlog (win32):
# (change requires restart)
#event_source = 'Postgresql'
# - When to Log -
#client_min_messages = notice # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# log
# notice
# warning
# error
#log_min_messages = warning # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic
#log_min_error_statement = error # values in order of decreasing detail:
# debug5
# debug4
# debug3
# debug2
# debug1
# info
# notice
# warning
# error
# log
# fatal
# panic (effectively off)
#log_min_duration_statement = -1 # -1 is disabled,0 logs all statements
# and their durations,> 0 logs only
# statements running at least this number
# of milliseconds
# - What to Log -
#debug_print_parse = off
#debug_print_rewritten = off
#debug_print_plan = off
#debug_pretty_print = on
#log_checkpoints = off
#log_connections = off
#log_disconnections = off
#log_duration = off
#log_error_verbosity = default # terse,default,or verbose messages
#log_hostname = off
log_line_prefix = '%m [%p] %q%u@%d ' # special values:
# %a = application name
# %u = user name
# %d = database name
# %r = remote host and port
# %h = remote host
# %p = process ID
# %t = timestamp without milliseconds
# %m = timestamp with milliseconds
# %n = timestamp with milliseconds (as a Unix epoch)
# %i = command tag
# %e = sql state
# %c = session ID
# %l = session line number
# %s = session start timestamp
# %v = virtual transaction ID
# %x = transaction ID (0 if none)
# %q = stop here in non-session
# processes
# %% = '%'
# e.g. '<%u%%%d> '
#log_lock_waits = off # log lock waits >= deadlock_timeout
#log_statement = 'none' # none,ddl,mod,all
#log_replication_commands = off
#log_temp_files = -1 # log temporary files equal or larger
# than the specified size in kilobytes;
# -1 disables,0 logs all temp files
log_timezone = 'PRC'
# - Process Title -
cluster_name = '10/main' # added to process titles if nonempty
# (change requires restart)
#update_process_title = on
#------------------------------------------------------------------------------
# RUNTIME STATISTICS
#------------------------------------------------------------------------------
# - Query/Index Statistics Collector -
#track_activities = on
#track_counts = on
#track_io_timing = off
#track_functions = none # none,pl,all
#track_activity_query_size = 1024 # (change requires restart)
stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'
# - Statistics Monitoring -
#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------
#autovacuum = on # Enable autovacuum subprocess? 'on'
# requires track_counts to also be on.
#log_autovacuum_min_duration = -1 # -1 disables,0 logs all actions and
# their durations,> 0 logs only
# actions running at least this number
# of milliseconds.
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses
# (change requires restart)
#autovacuum_naptime = 1min # time between autovacuum runs
#autovacuum_vacuum_threshold = 50 # min number of row updates before
# vacuum
#autovacuum_analyze_threshold = 50 # min number of row updates before
# analyze
#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum
#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
# (change requires restart)
#autovacuum_multixact_freeze_max_age = 400000000 # maximum multixact age
# before forced vacuum
# (change requires restart)
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for
# autovacuum,in milliseconds;
# -1 means use vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovacuum,-1 means use
# vacuum_cost_limit
#------------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#------------------------------------------------------------------------------
# - Statement Behavior -
#search_path = '"$user",public' # schema names
#default_tablespace = '' # a tablespace name,'' uses the default
#temp_tablespaces = '' # a list of tablespace names,'' uses
# only default tablespace
#check_function_bodies = on
#default_transaction_isolation = 'read committed'
#default_transaction_read_only = off
#default_transaction_deferrable = off
#session_replication_role = 'origin'
#statement_timeout = 0 # in milliseconds,0 is disabled
#lock_timeout = 0 # in milliseconds,0 is disabled
#idle_in_transaction_session_timeout = 0 # in milliseconds,0 is disabled
#vacuum_freeze_min_age = 50000000
#vacuum_freeze_table_age = 150000000
#vacuum_multixact_freeze_min_age = 5000000
#vacuum_multixact_freeze_table_age = 150000000
#bytea_output = 'hex' # hex,escape
#xmlbinary = 'base64'
#xmloption = 'content'
#gin_fuzzy_search_limit = 0
#gin_pending_list_limit = 4MB
# - Locale and Formatting -
datestyle = 'iso,mdy'
#intervalstyle = 'postgres'
timezone = 'PRC'
#timezone_abbreviations = 'Default' # Select the set of available time zone
# abbreviations. Currently,there are
# Default
# Australia (historical usage)
# India
# You can create your own file in
# share/timezonesets/.
#extra_float_digits = 0 # min -15,max 3
#client_encoding = sql_ascii # actually,defaults to database
# encoding
# These settings are initialized by initdb,but they can be changed.
lc_messages = 'en_US.UTF-8' # locale for system error message
# strings
lc_monetary = 'zh_CN.UTF-8' # locale for monetary formatting
lc_numeric = 'zh_CN.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.english'
# - Other Defaults -
#dynamic_library_path = '$libdir'
#local_preload_libraries = ''
#session_preload_libraries = ''
#------------------------------------------------------------------------------
# LOCK MANAGEMENT
#------------------------------------------------------------------------------
#deadlock_timeout = 1s
#max_locks_per_transaction = 64 # min 10
# (change requires restart)
#max_pred_locks_per_transaction = 64 # min 10
# (change requires restart)
#max_pred_locks_per_relation = -2 # negative values mean
# (max_pred_locks_per_transaction
# / -max_pred_locks_per_relation) - 1
#max_pred_locks_per_page = 2 # min 0
#------------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#------------------------------------------------------------------------------
# - PrevIoUs Postgresql Versions -
#array_nulls = on
#backslash_quote = safe_encoding # on,or safe_encoding
#default_with_oids = off
#escape_string_warning = on
#lo_compat_privileges = off
#operator_precedence_warning = off
#quote_all_identifiers = off
#standard_conforming_strings = on
#synchronize_seqscans = on
# - Other Platforms and Clients -
#transform_null_equals = off
#------------------------------------------------------------------------------
# ERROR HANDLING
#------------------------------------------------------------------------------
#exit_on_error = off # terminate session on any error?
#restart_after_crash = on # reinitialize after backend crash?
#------------------------------------------------------------------------------
# CONFIG FILE INCLUDES
#------------------------------------------------------------------------------
# These options allow settings to be loaded from files other than the
# default postgresql.conf.
include_dir = 'conf.d' # include files ending in '.conf' from
# directory 'conf.d'
#include_if_exists = 'exists.conf' # include file only if it exists
#include = 'special.conf' # include file
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
# Add settings for extensions here
lwk@qwfys ~ $
这里，我们先将
#listen_addresses = 'localhost' # what IP address(es) to listen on;
改为
listen_addresses = '*' # what IP address(es) to listen on;
接着将
#password_encryption = md5 # md5 or scram-sha-256
改为
password_encryption = on # md5 or scram-sha-256
之后，我们先来浏览器一下文件pg_hba.conf内容，具体如下：
lwk@qwfys ~ $ sudo cat /etc/postgresql/10/main/pg_hba.conf
# Postgresql Client Authentication Configuration File
# ===================================================
#
# Refer to the "Client Authentication" section in the Postgresql
# documentation for a complete description of this file. A short
# synopsis follows.
#
# This file controls: which hosts are allowed to connect,how clients
# are authenticated,which Postgresql user names they can use,which
# databases they can access. Records take one of these forms:
#
# local DATABASE USER METHOD [OPTIONS]
# host DATABASE USER ADDRESS METHOD [OPTIONS]
# hostssl DATABASE USER ADDRESS METHOD [OPTIONS]
# hostnossl DATABASE USER ADDRESS METHOD [OPTIONS]
#
# (The uppercase items must be replaced by actual values.)
#
# The first field is the connection type: "local" is a Unix-domain
# socket,"host" is either a plain or SSL-encrypted TCP/IP socket,
# "hostssl" is an SSL-encrypted TCP/IP socket,and "hostnossl" is a
# plain TCP/IP socket.
#
# DATABASE can be "all","sameuser","samerole","replication",a
# database name,or a comma-separated list thereof. The "all"
# keyword does not match "replication". Access to replication
# must be enabled in a separate record (see example below).
#
# USER can be "all",a user name,a group name prefixed with "+",or a
# comma-separated list thereof. In both the DATABASE and USER fields
# you can also write a file name prefixed with "@" to include names
# from a separate file.
#
# ADDRESS specifies the set of hosts the record matches. It can be a
# host name,or it is made up of an IP address and a CIDR mask that is
# an integer (between 0 and 32 (IPv4) or 128 (IPv6) inclusive) that
# specifies the number of significant bits in the mask. A host name
# that starts with a dot (.) matches a suffix of the actual host name.
# Alternatively,you can write an IP address and netmask in separate
# columns to specify the set of hosts. Instead of a CIDR-address,you
# can write "samehost" to match any of the server's own IP addresses,
# or "samenet" to match any address in any subnet that the server is
# directly connected to.
#
# METHOD can be "trust","reject","md5","password","scram-sha-256",
# "gss","sspi","ident","peer","pam","ldap","radius" or "cert".
# Note that "password" sends passwords in clear text; "md5" or
# "scram-sha-256" are preferred since they send encrypted passwords.
#
# OPTIONS are a set of options for the authentication in the format
# NAME=VALUE. The available options depend on the different
# authentication methods -- refer to the "Client Authentication"
# section in the documentation for a list of which options are
# available for which authentication methods.
#
# Database and user names containing spaces,commas,quotes and other
# special characters must be quoted. Quoting one of the keywords
# "all","samerole" or "replication" makes the name lose
# its special character,and just match a database or username with
# that name.
#
# This file is read on server startup and when the server receives a
# SIGHUP signal. If you edit the file on a running system,you have to
# SIGHUP the server for the changes to take effect,
# or execute "SELECT pg_reload_conf()".
#
# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections,you need to add more
# "host" records. In that case you will also need to make Postgresql
# listen on a non-local interface via the listen_addresses
# configuration parameter,or via the -i or -h command line switches.
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can access the database using some other method.
# Noninteractive access to all databases is required during automatic
# maintenance (custom daily cronjobs,replication,and similar tasks).
#
# Database administrative login by Unix domain socket
local all postgres peer
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
#host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost,by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 md5
host replication all ::1/128 md5
lwk@qwfys ~ $
host all all 0.0.0.0 0.0.0.0 md5
为了从远程主机进行访问该数据库实例，我们需要打开防火墙，将端口5432开放给外面的主机，可以通过以下命令完成防火墙的设置。
lwk@qwfys ~ $ sudo ufw allow 5432
Rule added
Rule added (v6)
lwk@qwfys ~ $ sudo ufw status
Status: active
To Action From
-- ------ ----
5432 ALLOW Anywhere
5432 (v6) ALLOW Anywhere (v6)
lwk@qwfys ~ $
lwk@qwfys ~ $ sudo systemctl restart postgresql
lwk@qwfys ~ $ sudo systemctl status postgresql
● postgresql.service - Postgresql RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2018-05-15 05:31:27 CST; 3s ago
Process: 25067 ExecStart=/bin/true (code=exited,status=0/SUCCESS)
Main PID: 25067 (code=exited,status=0/SUCCESS)
May 15 05:31:27 qwfys systemd[1]: Starting Postgresql RDBMS...
May 15 05:31:27 qwfys systemd[1]: Started Postgresql RDBMS.
lwk@qwfys ~ $
我们看到数据库Postgresql实例启动成功，接下来，我们就可以通过客户端来管理该数据库系统了。Postgresql数据库客户端很多，这里主要讲一下psql和pgadmin4客户端，前者是一个命令行客户端，后者是一个基于Web的客户端。
pgadmin4管理
安装完成pgadmin4以后，系统菜单就会有pgadmin4菜单项，下面几幅图是我在Linux mint 18.3系统上的截图，因为Linux mint 18.x是基于Ubuntu 16.04 LTS构建的，所以，对于Ubuntu Desktop 16.04 LTS也是类似的，因为桌面环境不同，显示风格不太一致，但是功能是类似的。
Psql
lwk@qwfys ~ $ sudo -u postgres psql
[sudo] password for lwk:
psql (10.4 (Ubuntu 10.4-1.pgdg16.04+1))
Type "help" for help.
postgres=# help
You are using psql,the command-line interface to Postgresql.
Type: \copyright for distribution terms
\h for help with sql commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# \h
Available help:
ABORT ALTER SERVER CREATE CAST CREATE TABLE DROP EXTENSION DROP TEXT SEARCH TEMPLATE REVOKE ALTER AGGREGATE ALTER STATISTICS CREATE COLLATION CREATE TABLE AS DROP FOREIGN DATA WRAPPER DROP TRANSFORM ROLLBACK ALTER COLLATION ALTER SUBSCRIPTION CREATE CONVERSION CREATE TABLESPACE DROP FOREIGN TABLE DROP TRIGGER ROLLBACK PREPARED ALTER CONVERSION ALTER SYSTEM CREATE DATABASE CREATE TEXT SEARCH CONFIGURATION DROP FUNCTION DROP TYPE ROLLBACK TO SAVEPOINT ALTER DATABASE ALTER TABLE CREATE DOMAIN CREATE TEXT SEARCH DICTIONARY DROP GROUP DROP USER SAVEPOINT ALTER DEFAULT PRIVILEGES ALTER TABLESPACE CREATE EVENT TRIGGER CREATE TEXT SEARCH PARSER DROP INDEX DROP USER MAPPING SECURITY LABEL ALTER DOMAIN ALTER TEXT SEARCH CONFIGURATION CREATE EXTENSION CREATE TEXT SEARCH TEMPLATE DROP LANGUAGE DROP VIEW SELECT ALTER EVENT TRIGGER ALTER TEXT SEARCH DICTIONARY CREATE FOREIGN DATA WRAPPER CREATE TRANSFORM DROP MATERIALIZED VIEW END SELECT INTO ALTER EXTENSION ALTER TEXT SEARCH PARSER CREATE FOREIGN TABLE CREATE TRIGGER DROP OPERATOR EXECUTE SET ALTER FOREIGN DATA WRAPPER ALTER TEXT SEARCH TEMPLATE CREATE FUNCTION CREATE TYPE DROP OPERATOR CLASS EXPLAIN SET CONSTRAINTS ALTER FOREIGN TABLE ALTER TRIGGER CREATE GROUP CREATE USER DROP OPERATOR FAMILY FETCH SET ROLE ALTER FUNCTION ALTER TYPE CREATE INDEX CREATE USER MAPPING DROP OWNED GRANT SET SESSION AUTHORIZATION ALTER GROUP ALTER USER CREATE LANGUAGE CREATE VIEW DROP POLICY IMPORT FOREIGN SCHEMA SET TRANSACTION ALTER INDEX ALTER USER MAPPING CREATE MATERIALIZED VIEW DEALLOCATE DROP PUBLICATION INSERT SHOW ALTER LANGUAGE ALTER VIEW CREATE OPERATOR DECLARE DROP ROLE LISTEN START TRANSACTION ALTER LARGE OBJECT ANALYZE CREATE OPERATOR CLASS DELETE DROP RULE LOAD TABLE ALTER MATERIALIZED VIEW BEGIN CREATE OPERATOR FAMILY DISCARD DROP SCHEMA LOCK TRUNCATE ALTER OPERATOR CHECKPOINT CREATE POLICY DO DROP SEQUENCE MOVE UNLISTEN ALTER OPERATOR CLASS CLOSE CREATE PUBLICATION DROP ACCESS METHOD DROP SERVER NOTIFY UPDATE ALTER OPERATOR FAMILY CLUSTER CREATE ROLE DROP AGGREGATE DROP STATISTICS PREPARE VACUUM ALTER POLICY COMMENT CREATE RULE DROP CAST DROP SUBSCRIPTION PREPARE TRANSACTION VALUES ALTER PUBLICATION COMMIT CREATE SCHEMA DROP COLLATION DROP TABLE REASSIGN OWNED WITH ALTER ROLE COMMIT PREPARED CREATE SEQUENCE DROP CONVERSION DROP TABLESPACE REFRESH MATERIALIZED VIEW ALTER RULE COPY CREATE SERVER DROP DATABASE DROP TEXT SEARCH CONFIGURATION REINDEX ALTER SCHEMA CREATE ACCESS METHOD CREATE STATISTICS DROP DOMAIN DROP TEXT SEARCH DICTIONARY RELEASE SAVEPOINT ALTER SEQUENCE CREATE AGGREGATE CREATE SUBSCRIPTION DROP EVENT TRIGGER DROP TEXT SEARCH PARSER RESET postgres=#\? General \copyright show Postgresql usage and distribution terms \crosstabview [COLUMNS] execute query and display results in crosstab \errverbose show most recent error message at maximum verbosity \g [FILE] or ; execute query (and send results to file or |pipe)
\gexec execute query,then execute each value in its result
\gset [PREFIX] execute query and store results in psql variables
\gx [FILE] as \g,but forces expanded output mode
\q quit psql
\watch [SEC] execute query every SEC seconds
Help
\? [commands] show help on backslash commands \? options show help on psql command-line options \? variables show help on special variables \h [NAME] help on Syntax of sql commands,* for all commands Query Buffer \e [FILE] [LINE] edit the query buffer (or file) with external editor \ef [FUNCNAME [LINE]] edit function definition with external editor \ev [VIEWNAME [LINE]] edit view definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file \w FILE write query buffer to file Input/Output \copy ... perform sql COPY with data stream to the client host \echo [STRING] write string to standard output \i FILE execute commands from file \ir FILE as \i,but relative to location of current script \o [FILE] send all query results to file or |pipe \qecho [STRING] write string to query output stream (see \o) Conditional \if EXPR begin conditional block \elif EXPR alternative within current conditional block \else final alternative within current conditional block \endif end conditional block Informational (options: S = show system objects,+ = additional detail) \d[S+] list tables,views,and sequences \d[S+] NAME describe table,view,sequence,or index \da[S] [PATTERN] list aggregates \dA[+] [PATTERN] list access methods \db[+] [PATTERN] list tablespaces \dc[S+] [PATTERN] list conversions \dC[+] [PATTERN] list casts \dd[S] [PATTERN] show object descriptions not displayed elsewhere \dD[S+] [PATTERN] list domains \ddp [PATTERN] list default privileges \dE[S+] [PATTERN] list foreign tables \det[+] [PATTERN] list foreign tables \des[+] [PATTERN] list foreign servers \deu[+] [PATTERN] list user mappings \dew[+] [PATTERN] list foreign-data wrappers \df[antw][S+] [PATRN] list [only agg/normal/trigger/window] functions \dF[+] [PATTERN] list text search configurations \dFd[+] [PATTERN] list text search dictionaries \dFp[+] [PATTERN] list text search parsers \dFt[+] [PATTERN] list text search templates \dg[S+] [PATTERN] list roles \di[S+] [PATTERN] list indexes \dl list large objects,same as \lo_list \dFd[+] [PATTERN] list text search dictionaries \dFp[+] [PATTERN] list text search parsers \dFt[+] [PATTERN] list text search templates \dg[S+] [PATTERN] list roles \di[S+] [PATTERN] list indexes \dl list large objects,same as \lo_list \dL[S+] [PATTERN] list procedural languages \dm[S+] [PATTERN] list materialized views \dn[S+] [PATTERN] list schemas \do[S] [PATTERN] list operators \dO[S+] [PATTERN] list collations \dp [PATTERN] list table,and sequence access privileges \drds [PATRN1 [PATRN2]] list per-database role settings \dRp[+] [PATTERN] list replication publications \dRs[+] [PATTERN] list replication subscriptions \ds[S+] [PATTERN] list sequences \dt[S+] [PATTERN] list tables \dT[S+] [PATTERN] list data types \du[S+] [PATTERN] list roles \dv[S+] [PATTERN] list views \dx[+] [PATTERN] list extensions \dy [PATTERN] list event triggers \l[+] [PATTERN] list databases \sf[+] FUNCNAME show a function's definition \sv[+] VIEWNAME show a view's definition \z [PATTERN] same as \dp Formatting \a toggle between unaligned and aligned output mode \C [STRING] set table title,or unset if none \f [STRING] show or set field separator for unaligned query output \H toggle HTML output mode (currently off) \pset [NAME [VALUE]] set table output option (NAME := {border|columns|expanded|fieldsep|fieldsep_zero| footer|format|linestyle|null|numericlocale|pager| pager_min_lines|recordsep|recordsep_zero|tableattr|title| tuples_only|unicode_border_linestyle| unicode_column_linestyle|unicode_header_linestyle}) \t [on|off] show only rows (currently off) \T [STRING] set HTML <table> tag attributes,or unset if none \x [on|off|auto] toggle expanded output (currently off) Connection \c[onnect] {[DBNAME|- USER|- HOST|- PORT|-] | conninfo} connect to new database (currently "postgres") \conninfo display information about current connection \encoding [ENCODING] show or set client encoding \password [USERNAME] securely change the password for a user Operating System \cd [DIR] change the current working directory \setenv NAME [VALUE] set or unset environment variable \timing [on|off] toggle timing of commands (currently off) \! [COMMAND] execute command in shell or start interactive shell Variables \prompt [TEXT] NAME prompt user to set internal variable \set [NAME [VALUE]] set internal variable,or list all if no parameters \unset NAME unset (delete) internal variable Large Objects \lo_export LOBOID FILE \lo_import FILE [COMMENT] \lo_list \lo_unlink LOBOID large object operations (END)
这个时候按q就会退出上下文帮助
postgres=#
postgres=# \q
lwk@qwfys ~ $
通常项目开发过程中，我们会采用pgadmin4客户端完成应用软件的开发，对于运维人员，他们会采用psql完成相关的配置与管理。
参考资料
