root@zetawiki:~# aptitude show postgresql | grep State
State: not installed
(→확인 2) |
(→같이 보기) |
||
69번째 줄: | 69번째 줄: | ||
*[[우분투 MySQL 설치]] | *[[우분투 MySQL 설치]] | ||
*[[리눅스 psql]] | *[[리눅스 psql]] | ||
*[[sudo: unable to execute /usr/bin/psql: Permission denied]] | |||
[[분류: apt-get]] | [[분류: apt-get]] | ||
[[분류: PostgreSQL]] | [[분류: PostgreSQL]] |
2016년 3월 23일 (수) 14:04 판
- 우분투 PostgreSQL 서버 설치
- 우분투 postgres 설치
1 확인
Copy
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:
libpq5 postgresql-9.3 postgresql-client-9.3 postgresql-client-common
postgresql-common
Suggested packages:
oidentd ident-server locales-all postgresql-doc-9.3
The following NEW packages will be installed:
libpq5 postgresql postgresql-9.3 postgresql-client-9.3
postgresql-client-common postgresql-common
0 upgraded, 6 newly installed, 0 to remove and 145 not upgraded.
Need to get 889 kB/3,685 kB of archives.
After this operation, 15.5 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 libpq5 amd64 9.3.11-0ubuntu0.14.04 [80.6 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu/ trusty-updates/main postgresql-client-common all 154ubuntu1 [25.4 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) ...
Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
3 확인 2
Copy
root@zetawiki:~# dpkg -l | grep postgres
ii postgresql 9.3+154ubuntu1 all object-relational SQL database (supported version)
ii postgresql-9.3 9.3.11-0ubuntu0.14.04 amd64 object-relational SQL database, version 9.3 server
ii postgresql-client-9.3 9.3.11-0ubuntu0.14.04 amd64 front-end programs for PostgreSQL 9.3
ii postgresql-client-common 154ubuntu1 all manager for multiple PostgreSQL client versions
ii postgresql-common 154ubuntu1 all PostgreSQL database-cluster manager
Copy
root@zetawiki:~# cat /etc/passwd | grep postgres
postgres:x:111:121:PostgreSQL administrator,,,:/var/lib/postgresql:/bin/bash
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 같이 보기
편집자 Jmnote Jmnote bot John Jeong
로그인하시면 댓글을 쓸 수 있습니다.