在 Ubuntu 14.04 下安装 pgAdmin Ⅲ
pgAdmin 是一个设计、维护、管理 PostgreSQL 数据库的通用工具。pgAdmin 也是一个 * nix 和 Windows 平台的 PostgreSQL 数据库全面设计、管理系统。pgAdmin 由世界各地 PostgreSQL 专家社区开发，可支持十多种语言。pgAdmin 可运行于 Linux、FreeBSD、Solaris、Mac OS X 和 Windows 平台。
pgAdmin 是在 PostgreSQL 许可下发布的自由软件。pgAdmin 可在 Artistic 许可条款下自由使用，且贴附 Artistic 许可条款还可再分布。pgAdmin 项目由 pgAdmin 开发团队管理。
pgAdmin 是一个流行、功能丰富的世界最先进开源数据库 PostgreSQL、PostgreSQL 商业版及派生版 (譬如：Postgres Plus Advanced Server、Greenplum 数据库) 的开放源码管理和开发平台。
智能编辑重构 批处理式 "数字 Python IDE" 集成开发环境 (集成高效 Cython PyInstaller 批处理小程序)
http://dt.digitser.cn/zh-CN/ide/idepy/index.html
pgAdmin 是设计用来应对所有用户，从编写简单 SQL 查询到开发复杂数据库需求的。图形化界面可支持所有 PostgreSQL 特性并可轻松管理 PostgreSQL 数据库。pgAdmin 含有语法高亮 SQL 编辑器、服务器侧代码编辑器、SQL/批处理/ Shell 作业调度代理，支持 Slony-I 复制引擎及更多。可使用 TCP/IP 或 Unix 域套接字 (在 *nix 平台) 连接服务器，并可 SSL 安全加密。没有额外驱动程序需要与数据库服务器进行通信。
pgAdmin Ⅲ 是原 pgAdmin 和 pgAdmin II 产品的继任者；虽很流行，但设计方面的局限性会妨碍 pgAdmin Ⅲ “更上一层楼”。pgAdmin Ⅲ 以 C++ 编写，采用优秀 wxWidgets (原名wxWindows) 跨平台工具包。使用本地 libpq 库连接 PostgreSQL。
01、以 apt-get 方式安装 pgAdmin Ⅲ
- root:~# apt-get install pgadmin3
- Reading package lists... Done
- Building dependency tree
- Reading state information... Done
- The following extra packages will be installed:
- hicolor-icon-theme libatk1.0-0 libatk1.0-data libdrm-intel1 libdrm-nouveau2
- libdrm-radeon1 libgdk-pixbuf2.0-0 libgdk-pixbuf2.0-common libgl1-mesa-dri
- libgl1-mesa-glx libglapi-mesa libgtk2.0-0 libgtk2.0-bin libgtk2.0-common
- libjasper1 libllvm3.4 libpciaccess0 libtxc-dxtn-s2tc0 libwxbase2.8-0
- libwxgtk2.8-0 libx11-xcb1 libxcb-dri2-0 libxcb-dri3-0 libxcb-glx0
- libxcb-present0 libxcb-sync1 libxcomposite1 libxcursor1 libxdamage1
- libxfixes3 libxi6 libxinerama1 libxrandr2 libxshmfence1 libxxf86vm1
- pgadmin3-data pgagent
- Suggested packages:
- libglide3 librsvg2-common gvfs libjasper-runtime postgresql-contrib
- The following NEW packages will be installed:
- hicolor-icon-theme libatk1.0-0 libatk1.0-data libdrm-intel1 libdrm-nouveau2
- libdrm-radeon1 libgdk-pixbuf2.0-0 libgdk-pixbuf2.0-common libgl1-mesa-dri
- libgl1-mesa-glx libglapi-mesa libgtk2.0-0 libgtk2.0-bin libgtk2.0-common
- libjasper1 libllvm3.4 libpciaccess0 libtxc-dxtn-s2tc0 libwxbase2.8-0
- libwxgtk2.8-0 libx11-xcb1 libxcb-dri2-0 libxcb-dri3-0 libxcb-glx0
- libxcb-present0 libxcb-sync1 libxcomposite1 libxcursor1 libxdamage1
- libxfixes3 libxi6 libxinerama1 libxrandr2 libxshmfence1 libxxf86vm1 pgadmin3
- pgadmin3-data pgagent
- 0 upgraded, 38 newly installed, 0 to remove and 0 not upgraded.
- Need to get 20.6 MB of archives.
- After this operation, 103 MB of additional disk space will be used.
- Do you want to continue? [Y/n] y
- Get:1 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libatk1.0-data all 2.10.0-2ubuntu2 [13.7 kB]
- Get:2 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libatk1.0-0 amd64 2.10.0-2ubuntu2 [50.9 kB]
- Get:3 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libpciaccess0 amd64 0.13.2-1 [20.4 kB]
- Get:4 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libdrm-intel1 amd64 2.4.56-1~ubuntu1 [54.5 kB]
- Get:5 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libdrm-nouveau2 amd64 2.4.56-1~ubuntu1 [13.7 kB]
- Get:6 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libdrm-radeon1 amd64 2.4.56-1~ubuntu1 [23.3 kB]
- Get:7 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libjasper1 amd64 1.900.1-14ubuntu3.1 [129 kB]
- Get:8 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libgdk-pixbuf2.0-common all 2.30.7-0ubuntu1 [8,610 B]
- Get:9 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libgdk-pixbuf2.0-0 amd64 2.30.7-0ubuntu1 [160 kB]
- Get:10 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libllvm3.4 amd64 1:3.4-1ubuntu3 [6,540 kB]
- Get:11 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libgl1-mesa-dri amd64 10.1.3-0ubuntu0.2 [4,567 kB]
- Get:12 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libglapi-mesa amd64 10.1.3-0ubuntu0.2 [21.4 kB]
- Get:13 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libx11-xcb1 amd64 2:1.6.2-1ubuntu2 [9,426 B]
- Get:14 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcb-dri2-0 amd64 1.10-2ubuntu1 [6,710 B]
- Get:15 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcb-dri3-0 amd64 1.10-2ubuntu1 [5,118 B]
- Get:16 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcb-glx0 amd64 1.10-2ubuntu1 [20.0 kB]
- Get:17 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcb-present0 amd64 1.10-2ubuntu1 [5,254 B]
- Get:18 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcb-sync1 amd64 1.10-2ubuntu1 [8,090 B]
- Get:19 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxdamage1 amd64 1:1.1.4-1ubuntu1 [7,612 B]
- Get:20 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxfixes3 amd64 1:5.0.1-1ubuntu1 [11.7 kB]
- Get:21 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxshmfence1 amd64 1.1-2 [4,644 B]
- Get:22 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxxf86vm1 amd64 1:1.1.3-1 [11.7 kB]
- Get:23 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libgl1-mesa-glx amd64 10.1.3-0ubuntu0.2 [114 kB]
- Get:24 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libgtk2.0-common all 2.24.23-0ubuntu1.1 [121 kB]
- Get:25 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcomposite1 amd64 1:0.4.4-1 [7,714 B]
- Get:26 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxcursor1 amd64 1:1.1.14-1 [22.8 kB]
- Get:27 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxi6 amd64 2:1.7.1.901-1ubuntu1 [31.9 kB]
- Get:28 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxinerama1 amd64 2:1.1.3-1 [7,908 B]
- Get:29 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libxrandr2 amd64 2:1.4.2-1 [16.6 kB]
- Get:30 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libgtk2.0-0 amd64 2.24.23-0ubuntu1.1 [1,733 kB]
- Get:31 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/universe libwxbase2.8-0 amd64 2.8.12.1+dfsg-2ubuntu2 [460 kB]
- Get:32 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/universe libwxgtk2.8-0 amd64 2.8.12.1+dfsg-2ubuntu2 [2,371 kB]
- Get:33 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main libtxc-dxtn-s2tc0 amd64 0~git20131104-1.1 [51.8 kB]
- Get:34 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/main hicolor-icon-theme all 0.13-1 [7,140 B]
- Get:35 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty-updates/main libgtk2.0-bin amd64 2.24.23-0ubuntu1.1 [9,738 B]
- Get:36 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/universe pgadmin3-data all 1.18.1-2 [1,823 kB]
- Get:37 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/universe pgadmin3 amd64 1.18.1-2 [2,104 kB]
- Get:38 [url]http://mirrors.aliyun.com/ubuntu/[/url] trusty/universe pgagent amd64 3.3.0-1 [39.8 kB]
- Fetched 20.6 MB in 6s (3,110 kB/s)
- Extracting templates from packages: 100%
- Selecting previously unselected package libatk1.0-data.
- (Reading database ... 163016 files and directories currently installed.)
- Preparing to unpack .../libatk1.0-data_2.10.0-2ubuntu2_all.deb ...
- Unpacking libatk1.0-data (2.10.0-2ubuntu2) ...
- Selecting previously unselected package libatk1.0-0:amd64.
- Preparing to unpack .../libatk1.0-0_2.10.0-2ubuntu2_amd64.deb ...
- Unpacking libatk1.0-0:amd64 (2.10.0-2ubuntu2) ...
- Selecting previously unselected package libpciaccess0:amd64.
- Preparing to unpack .../libpciaccess0_0.13.2-1_amd64.deb ...
- Unpacking libpciaccess0:amd64 (0.13.2-1) ...
- Selecting previously unselected package libdrm-intel1:amd64.
- Preparing to unpack .../libdrm-intel1_2.4.56-1~ubuntu1_amd64.deb ...
- Unpacking libdrm-intel1:amd64 (2.4.56-1~ubuntu1) ...
- Selecting previously unselected package libdrm-nouveau2:amd64.
- Preparing to unpack .../libdrm-nouveau2_2.4.56-1~ubuntu1_amd64.deb ...
- Unpacking libdrm-nouveau2:amd64 (2.4.56-1~ubuntu1) ...
- Selecting previously unselected package libdrm-radeon1:amd64.
- Preparing to unpack .../libdrm-radeon1_2.4.56-1~ubuntu1_amd64.deb ...
- Unpacking libdrm-radeon1:amd64 (2.4.56-1~ubuntu1) ...
- Selecting previously unselected package libjasper1:amd64.
- Preparing to unpack .../libjasper1_1.900.1-14ubuntu3.1_amd64.deb ...
- Unpacking libjasper1:amd64 (1.900.1-14ubuntu3.1) ...
- Selecting previously unselected package libgdk-pixbuf2.0-common.
- Preparing to unpack .../libgdk-pixbuf2.0-common_2.30.7-0ubuntu1_all.deb ...
- Unpacking libgdk-pixbuf2.0-common (2.30.7-0ubuntu1) ...
- Selecting previously unselected package libgdk-pixbuf2.0-0:amd64.
- Preparing to unpack .../libgdk-pixbuf2.0-0_2.30.7-0ubuntu1_amd64.deb ...
- Unpacking libgdk-pixbuf2.0-0:amd64 (2.30.7-0ubuntu1) ...
- Selecting previously unselected package libllvm3.4:amd64.
- Preparing to unpack .../libllvm3.4_1%3a3.4-1ubuntu3_amd64.deb ...
- Unpacking libllvm3.4:amd64 (1:3.4-1ubuntu3) ...
- Selecting previously unselected package libgl1-mesa-dri:amd64.
- Preparing to unpack .../libgl1-mesa-dri_10.1.3-0ubuntu0.2_amd64.deb ...
- Unpacking libgl1-mesa-dri:amd64 (10.1.3-0ubuntu0.2) ...
- Selecting previously unselected package libglapi-mesa:amd64.
- Preparing to unpack .../libglapi-mesa_10.1.3-0ubuntu0.2_amd64.deb ...
- Unpacking libglapi-mesa:amd64 (10.1.3-0ubuntu0.2) ...
- Selecting previously unselected package libx11-xcb1:amd64.
- Preparing to unpack .../libx11-xcb1_2%3a1.6.2-1ubuntu2_amd64.deb ...
- Unpacking libx11-xcb1:amd64 (2:1.6.2-1ubuntu2) ...
- Selecting previously unselected package libxcb-dri2-0:amd64.
- Preparing to unpack .../libxcb-dri2-0_1.10-2ubuntu1_amd64.deb ...
- Unpacking libxcb-dri2-0:amd64 (1.10-2ubuntu1) ...
- Selecting previously unselected package libxcb-dri3-0:amd64.
- Preparing to unpack .../libxcb-dri3-0_1.10-2ubuntu1_amd64.deb ...
- Unpacking libxcb-dri3-0:amd64 (1.10-2ubuntu1) ...
- Selecting previously unselected package libxcb-glx0:amd64.
- Preparing to unpack .../libxcb-glx0_1.10-2ubuntu1_amd64.deb ...
- Unpacking libxcb-glx0:amd64 (1.10-2ubuntu1) ...
- Selecting previously unselected package libxcb-present0:amd64.
- Preparing to unpack .../libxcb-present0_1.10-2ubuntu1_amd64.deb ...
- Unpacking libxcb-present0:amd64 (1.10-2ubuntu1) ...
- Selecting previously unselected package libxcb-sync1:amd64.
- Preparing to unpack .../libxcb-sync1_1.10-2ubuntu1_amd64.deb ...
- Unpacking libxcb-sync1:amd64 (1.10-2ubuntu1) ...
- Selecting previously unselected package libxdamage1:amd64.
- Preparing to unpack .../libxdamage1_1%3a1.1.4-1ubuntu1_amd64.deb ...
- Unpacking libxdamage1:amd64 (1:1.1.4-1ubuntu1) ...
- Selecting previously unselected package libxfixes3:amd64.
- Preparing to unpack .../libxfixes3_1%3a5.0.1-1ubuntu1_amd64.deb ...
- Unpacking libxfixes3:amd64 (1:5.0.1-1ubuntu1) ...
- Selecting previously unselected package libxshmfence1:amd64.
- Preparing to unpack .../libxshmfence1_1.1-2_amd64.deb ...
- Unpacking libxshmfence1:amd64 (1.1-2) ...
- Selecting previously unselected package libxxf86vm1:amd64.
- Preparing to unpack .../libxxf86vm1_1%3a1.1.3-1_amd64.deb ...
- Unpacking libxxf86vm1:amd64 (1:1.1.3-1) ...
- Selecting previously unselected package libgl1-mesa-glx:amd64.
- Preparing to unpack .../libgl1-mesa-glx_10.1.3-0ubuntu0.2_amd64.deb ...
- Unpacking libgl1-mesa-glx:amd64 (10.1.3-0ubuntu0.2) ...
- Selecting previously unselected package libgtk2.0-common.
- Preparing to unpack .../libgtk2.0-common_2.24.23-0ubuntu1.1_all.deb ...
- Unpacking libgtk2.0-common (2.24.23-0ubuntu1.1) ...
- Selecting previously unselected package libxcomposite1:amd64.
- Preparing to unpack .../libxcomposite1_1%3a0.4.4-1_amd64.deb ...
- Unpacking libxcomposite1:amd64 (1:0.4.4-1) ...
- Selecting previously unselected package libxcursor1:amd64.
- Preparing to unpack .../libxcursor1_1%3a1.1.14-1_amd64.deb ...
- Unpacking libxcursor1:amd64 (1:1.1.14-1) ...
- Selecting previously unselected package libxi6:amd64.
- Preparing to unpack .../libxi6_2%3a1.7.1.901-1ubuntu1_amd64.deb ...
- Unpacking libxi6:amd64 (2:1.7.1.901-1ubuntu1) ...
- Selecting previously unselected package libxinerama1:amd64.
- Preparing to unpack .../libxinerama1_2%3a1.1.3-1_amd64.deb ...
| 
