CentOS 7 PostgreSQL ¼³Ä¡ ¹× »ç¿ë¹ý
https://www.ehostidc.co.kr/hosting/domestic.php (390)https://www.ehostidc.co.kr/colocation/colocation.php (482)
1) PostgreSQL 설치 |
[root@master ~]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-160; [root@master ~]# yum install postgresql11-server postgresql11-contrib |
2) postsql 실행 |
[root@master ~]# /usr/pgsql-11/bin/postgresql-11-setup initdb [root@master ~]# systemctl start postgresql-11 [root@master ~]# systemctl enable postgresql-11 |
3) postgresql /196;컬 1217;속 |
[root@master ~]# su R11; postgres 160;*PostgreSql160;설치시 1088;ᇼ1; 생성.104;lj16; 계1221; -bash-4.2$ psql postgres=# \q 160;*PostgreSql160;1217;속 1333;료 |
4) databases 확1064; 0143; 신규 데1060;터베1060;스 생성 |
postgres=# \l postgres=# create database [DB Name]; |
5) table 160;생성 |
postgres=# CREATE TABLE [데1060;터베1060;스명]( title varchar(256) NOT NULL, contents varchar NOT NULL, date date NOT NULL, name varchar(20) NOT NULL ); postgres=# \dt |
6) 사용1088; 계1221; 생성 |
postgres=# select * from pg_user;160; postgres=# CREATE USER [사용1088;명] PASSWORD '[비0128;번호]'; postgres=# select * from pg_user;160; |
7) 사용1088; 계1221; 권한 추가 |
postgres=# alter role [사용1088;명] [추가 권한]; postgres=# \du 160;*사용1088;명 0143; 권한 확1064; |