1) PostgreSQL 설치

[root@master ~]# yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat- 

[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  *PostgreSql 설치시 1088;ᇼ1; 생성.104;lj16; 계1221;

-bash-4.2$ psql

postgres=# \q  *PostgreSql 1217;속 1333;료

4) databases 확1064; 0143; 신규 데1060;터베1060;스 생성

postgres=# \l

postgres=# create database [DB Name];

5) table  생성

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; 

postgres=# CREATE USER [사용1088;명] PASSWORD '[비0128;번호]';

postgres=# select * from pg_user; 

7) 사용1088; 계1221; 권한 추가

postgres=# alter role [사용1088;명] [추가 권한];

postgres=# \du  *사용1088;명 0143; 권한 확1064;