在 Ubuntu 14.04 下安装 pgAdmin Ⅲ
在 Ubuntu14.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
Get:1 http://mirrors.aliyun.com/ubuntu/ trusty/main libatk1.0-data all 2.10.0-2ubuntu2
Get:2 http://mirrors.aliyun.com/ubuntu/ trusty/main libatk1.0-0 amd64 2.10.0-2ubuntu2
Get:3 http://mirrors.aliyun.com/ubuntu/ trusty/main libpciaccess0 amd64 0.13.2-1
Get:4 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libdrm-intel1 amd64 2.4.56-1~ubuntu1
Get:5 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libdrm-nouveau2 amd64 2.4.56-1~ubuntu1
Get:6 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libdrm-radeon1 amd64 2.4.56-1~ubuntu1
Get:7 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libjasper1 amd64 1.900.1-14ubuntu3.1
Get:8 http://mirrors.aliyun.com/ubuntu/ trusty/main libgdk-pixbuf2.0-common all 2.30.7-0ubuntu1
Get:9 http://mirrors.aliyun.com/ubuntu/ trusty/main libgdk-pixbuf2.0-0 amd64 2.30.7-0ubuntu1
Get:10 http://mirrors.aliyun.com/ubuntu/ trusty/main libllvm3.4 amd64 1:3.4-1ubuntu3
Get:11 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libgl1-mesa-dri amd64 10.1.3-0ubuntu0.2
Get:12 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libglapi-mesa amd64 10.1.3-0ubuntu0.2
Get:13 http://mirrors.aliyun.com/ubuntu/ trusty/main libx11-xcb1 amd64 2:1.6.2-1ubuntu2
Get:14 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcb-dri2-0 amd64 1.10-2ubuntu1
Get:15 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcb-dri3-0 amd64 1.10-2ubuntu1
Get:16 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcb-glx0 amd64 1.10-2ubuntu1
Get:17 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcb-present0 amd64 1.10-2ubuntu1
Get:18 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcb-sync1 amd64 1.10-2ubuntu1
Get:19 http://mirrors.aliyun.com/ubuntu/ trusty/main libxdamage1 amd64 1:1.1.4-1ubuntu1
Get:20 http://mirrors.aliyun.com/ubuntu/ trusty/main libxfixes3 amd64 1:5.0.1-1ubuntu1
Get:21 http://mirrors.aliyun.com/ubuntu/ trusty/main libxshmfence1 amd64 1.1-2
Get:22 http://mirrors.aliyun.com/ubuntu/ trusty/main libxxf86vm1 amd64 1:1.1.3-1
Get:23 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libgl1-mesa-glx amd64 10.1.3-0ubuntu0.2
Get:24 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libgtk2.0-common all 2.24.23-0ubuntu1.1
Get:25 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcomposite1 amd64 1:0.4.4-1
Get:26 http://mirrors.aliyun.com/ubuntu/ trusty/main libxcursor1 amd64 1:1.1.14-1
Get:27 http://mirrors.aliyun.com/ubuntu/ trusty/main libxi6 amd64 2:1.7.1.901-1ubuntu1
Get:28 http://mirrors.aliyun.com/ubuntu/ trusty/main libxinerama1 amd64 2:1.1.3-1
Get:29 http://mirrors.aliyun.com/ubuntu/ trusty/main libxrandr2 amd64 2:1.4.2-1
Get:30 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libgtk2.0-0 amd64 2.24.23-0ubuntu1.1
Get:31 http://mirrors.aliyun.com/ubuntu/ trusty/universe libwxbase2.8-0 amd64 2.8.12.1+dfsg-2ubuntu2
Get:32 http://mirrors.aliyun.com/ubuntu/ trusty/universe libwxgtk2.8-0 amd64 2.8.12.1+dfsg-2ubuntu2
Get:33 http://mirrors.aliyun.com/ubuntu/ trusty/main libtxc-dxtn-s2tc0 amd64 0~git20131104-1.1
Get:34 http://mirrors.aliyun.com/ubuntu/ trusty/main hicolor-icon-theme all 0.13-1
Get:35 http://mirrors.aliyun.com/ubuntu/ trusty-updates/main libgtk2.0-bin amd64 2.24.23-0ubuntu1.1
Get:36 http://mirrors.aliyun.com/ubuntu/ trusty/universe pgadmin3-data all 1.18.1-2
Get:37 http://mirrors.aliyun.com/ubuntu/ trusty/universe pgadmin3 amd64 1.18.1-2
Get:38 http://mirrors.aliyun.com/ubuntu/ trusty/universe pgagent amd64 3.3.0-1
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 ...
Unpacking libxinerama1:amd64 (2:1.1.3-1) ...
Selecting previously unselected package libxrandr2:amd64.
Preparing to unpack .../libxrandr2_2%3a1.4.2-1_amd64.deb ...
Unpacking libxrandr2:amd64 (2:1.4.2-1) ...
Selecting previously unselected package libgtk2.0-0:amd64.
Preparing to unpack .../libgtk2.0-0_2.24.23-0ubuntu1.1_amd64.deb ...
Unpacking libgtk2.0-0:amd64 (2.24.23-0ubuntu1.1) ...
Selecting previously unselected package libwxbase2.8-0:amd64.
Preparing to unpack .../libwxbase2.8-0_2.8.12.1+dfsg-2ubuntu2_amd64.deb ...
Unpacking libwxbase2.8-0:amd64 (2.8.12.1+dfsg-2ubuntu2) ...
Selecting previously unselected package libwxgtk2.8-0:amd64.
Preparing to unpack .../libwxgtk2.8-0_2.8.12.1+dfsg-2ubuntu2_amd64.deb ...
Unpacking libwxgtk2.8-0:amd64 (2.8.12.1+dfsg-2ubuntu2) ...
Selecting previously unselected package libtxc-dxtn-s2tc0:amd64.
Preparing to unpack .../libtxc-dxtn-s2tc0_0~git20131104-1.1_amd64.deb ...
Unpacking libtxc-dxtn-s2tc0:amd64 (0~git20131104-1.1) ...
Selecting previously unselected package hicolor-icon-theme.
Preparing to unpack .../hicolor-icon-theme_0.13-1_all.deb ...
Unpacking hicolor-icon-theme (0.13-1) ...
Selecting previously unselected package libgtk2.0-bin.
Preparing to unpack .../libgtk2.0-bin_2.24.23-0ubuntu1.1_amd64.deb ...
Unpacking libgtk2.0-bin (2.24.23-0ubuntu1.1) ...
Selecting previously unselected package pgadmin3-data.
Preparing to unpack .../pgadmin3-data_1.18.1-2_all.deb ...
Unpacking pgadmin3-data (1.18.1-2) ...
Selecting previously unselected package pgadmin3.
Preparing to unpack .../pgadmin3_1.18.1-2_amd64.deb ...
Unpacking pgadmin3 (1.18.1-2) ...
Selecting previously unselected package pgagent.
Preparing to unpack .../pgagent_3.3.0-1_amd64.deb ...
Unpacking pgagent (3.3.0-1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for mime-support (3.54ubuntu1.1) ...
Setting up libatk1.0-data (2.10.0-2ubuntu2) ...
Setting up libatk1.0-0:amd64 (2.10.0-2ubuntu2) ...
Setting up libpciaccess0:amd64 (0.13.2-1) ...
Setting up libdrm-intel1:amd64 (2.4.56-1~ubuntu1) ...
Setting up libdrm-nouveau2:amd64 (2.4.56-1~ubuntu1) ...
Setting up libdrm-radeon1:amd64 (2.4.56-1~ubuntu1) ...
Setting up libjasper1:amd64 (1.900.1-14ubuntu3.1) ...
Setting up libgdk-pixbuf2.0-common (2.30.7-0ubuntu1) ...
Setting up libgdk-pixbuf2.0-0:amd64 (2.30.7-0ubuntu1) ...
Setting up libllvm3.4:amd64 (1:3.4-1ubuntu3) ...
Setting up libgl1-mesa-dri:amd64 (10.1.3-0ubuntu0.2) ...
Setting up libglapi-mesa:amd64 (10.1.3-0ubuntu0.2) ...
Setting up libx11-xcb1:amd64 (2:1.6.2-1ubuntu2) ...
Setting up libxcb-dri2-0:amd64 (1.10-2ubuntu1) ...
Setting up libxcb-dri3-0:amd64 (1.10-2ubuntu1) ...
Setting up libxcb-glx0:amd64 (1.10-2ubuntu1) ...
Setting up libxcb-present0:amd64 (1.10-2ubuntu1) ...
Setting up libxcb-sync1:amd64 (1.10-2ubuntu1) ...
Setting up libxdamage1:amd64 (1:1.1.4-1ubuntu1) ...
Setting up libxfixes3:amd64 (1:5.0.1-1ubuntu1) ...
Setting up libxshmfence1:amd64 (1.1-2) ...
Setting up libxxf86vm1:amd64 (1:1.1.3-1) ...
Setting up libgl1-mesa-glx:amd64 (10.1.3-0ubuntu0.2) ...
update-alternatives: using /usr/lib/x86_64-linux-gnu/mesa/ld.so.conf to provide /etc/ld.so.conf.d/x86_64-linux-gnu_GL.conf (x86_64-linux-gnu_gl_conf) in auto mode
Setting up libgtk2.0-common (2.24.23-0ubuntu1.1) ...
Setting up libxcomposite1:amd64 (1:0.4.4-1) ...
Setting up libxcursor1:amd64 (1:1.1.14-1) ...
Setting up libxi6:amd64 (2:1.7.1.901-1ubuntu1) ...
Setting up libxinerama1:amd64 (2:1.1.3-1) ...
Setting up libxrandr2:amd64 (2:1.4.2-1) ...
Setting up libgtk2.0-0:amd64 (2.24.23-0ubuntu1.1) ...
Setting up libwxbase2.8-0:amd64 (2.8.12.1+dfsg-2ubuntu2) ...
Setting up libwxgtk2.8-0:amd64 (2.8.12.1+dfsg-2ubuntu2) ...
Setting up libtxc-dxtn-s2tc0:amd64 (0~git20131104-1.1) ...
update-alternatives: using /usr/lib/x86_64-linux-gnu/libtxc_dxtn_s2tc.so.0 to provide /usr/lib/x86_64-linux-gnu/libtxc_dxtn.so (libtxc-dxtn-x86_64-linux-gnu) in auto mode
Setting up hicolor-icon-theme (0.13-1) ...
Setting up libgtk2.0-bin (2.24.23-0ubuntu1.1) ...
Setting up pgadmin3-data (1.18.1-2) ...
Setting up pgadmin3 (1.18.1-2) ...
Setting up pgagent (3.3.0-1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.5) ...
root:~# 01、运行 pgAdmin Ⅲ
pgadmin3
版权声明：
本文为独家原创稿件，版权归 德云社区，未经许可不得转载。
页:
[1]