우분투 PostgreSQL 클라이언트 설치

1 확인[ | ]

Console

Copy

root@zetawiki:~# psql -V
The program 'psql' can be found in the following packages:
 * postgresql-client-common
 * postgres-xc-client
Try: apt-get install <selected package>

Console

Copy

root@zetawiki:~# aptitude search postgresql-client
p   postgresql-client                          - front-end programs for PostgreSQL (supported version)
v   postgresql-client:i386                     -                                                      
p   postgresql-client-9.3                      - front-end programs for PostgreSQL 9.3                
p   postgresql-client-9.3:i386                 - front-end programs for PostgreSQL 9.3                
c   postgresql-client-common                   - manager for multiple PostgreSQL client versions

2 설치[ | ]

Console

Copy

root@zetawiki:~# apt-get install postgresql-client
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libpq5 postgresql-client-9.3 postgresql-client-common
Suggested packages:
  postgresql-9.3 postgresql-doc-9.3
The following NEW packages will be installed:
  libpq5 postgresql-client postgresql-client-9.3 postgresql-client-common
0 upgraded, 4 newly installed, 0 to remove and 69 not upgraded.
Need to get 869 kB/895 kB of archives.
After this operation, 3,326 kB of additional disk space will be used.
Do you want to continue? [Y/n]

Console

Copy

Get:1 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main libpq5 amd64 9.3.10-0ubuntu0.14.04 [81.5 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main postgresql-client-9.3 amd64 9.3.10-0ubuntu0.14.04 [783 kB]
Get:3 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main postgresql-client all 9.3+154ubuntu1 [5,052 B]
Fetched 869 kB in 1s (444 kB/s)         
Selecting previously unselected package libpq5.
(Reading database ... 80478 files and directories currently installed.)
Preparing to unpack .../libpq5_9.3.10-0ubuntu0.14.04_amd64.deb ...
Unpacking libpq5 (9.3.10-0ubuntu0.14.04) ...
Selecting previously unselected package postgresql-client-common.
Preparing to unpack .../postgresql-client-common_154ubuntu1_all.deb ...
Unpacking postgresql-client-common (154ubuntu1) ...
Selecting previously unselected package postgresql-client-9.3.
Preparing to unpack .../postgresql-client-9.3_9.3.10-0ubuntu0.14.04_amd64.deb ...
Unpacking postgresql-client-9.3 (9.3.10-0ubuntu0.14.04) ...
Selecting previously unselected package postgresql-client.
Preparing to unpack .../postgresql-client_9.3+154ubuntu1_all.deb ...
Unpacking postgresql-client (9.3+154ubuntu1) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Setting up libpq5 (9.3.10-0ubuntu0.14.04) ...
Setting up postgresql-client-common (154ubuntu1) ...
Setting up postgresql-client-9.3 (9.3.10-0ubuntu0.14.04) ...
update-alternatives: using /usr/share/postgresql/9.3/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode
Setting up postgresql-client (9.3+154ubuntu1) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...

3 확인 2[ | ]

Console

Copy

root@zetawiki:~# psql -V
psql (PostgreSQL) 9.3.10

4 같이 보기[ | ]