우분투 PostgreSQL 설치

우분투 PostgreSQL 서버 설치
우분투 postgres 설치

1 확인

Copy

root@zetawiki:~# aptitude show postgresql | grep State
State: not installed

2 설치

Copy

root@zetawiki:~# apt-get install postgresql
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  postgresql-9.3 postgresql-common
Suggested packages:
  oidentd ident-server locales-all
The following NEW packages will be installed:
  postgresql postgresql-9.3 postgresql-common
0 upgraded, 3 newly installed, 0 to remove and 147 not upgraded.
Need to get 2,796 kB of archives.
After this operation, 12.2 MB of additional disk space will be used.
Do you want to continue? [Y/n]

Copy

Get:1 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main postgresql-common all 154ubuntu1 [103 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main postgresql-9.3 amd64 9.3.11-0ubuntu0.14.04 [2,688 kB]
... (생략)
Creating new cluster 9.3/main ...
  config /etc/postgresql/9.3/main
  data   /var/lib/postgresql/9.3/main
  locale en_US.UTF-8
  port   5432
update-alternatives: using /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode
 * Starting PostgreSQL 9.3 database server                                                    [ OK ] 
Setting up postgresql (9.3+154ubuntu1) ...

3 확인 2

Copy

root@zetawiki:~# aptitude show postgresql | grep State
State: installed

Copy

root@zetawiki:~# /etc/init.d/postgresql status
9.3/main (port 5432): online

Copy

root@zetawiki:~# netstat -tnlp | grep postgres
tcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      23680/postgres

4 같이 보기