PostgreSQL (3) - Admin

1. binaries download

https://www.postgresql.org/download/

2. User 생성

https://www.postgresql.org/docs/14/sql-createuser.html

CREATE USER name WITH SUPERUSER PASSWORD 'root1234';

3. Role 생성

https://www.postgresql.org/docs/14/sql-createrole.html

-- role 확인
# \du

# CREATE ROLE devuser with SUPERUSER CREATEDB REPLICATION BYPASSRLS;

4. 데이터베이스 생성

# 방법 1
$ initdb -D /usr/local/pgsql/data
# 방법 2 
$ pg_ctl -D /usr/local/pgsql/data initdb
# 방법 3
$ /usr/pgsql-14/bin/postgresql-14-setup initdb

5. 데이터베이스 시작

# 방법 1
$ postgres -D /usr/local/pgsql/data
# 방법 2 - 백그라운드 실행
$ postgres -D /usr/local/pgsql/data >logfile 2>&1 &
# 방법 3
$ pg_ctl start -l logfile
# 방법 4
$ su postgres -c 'pg_ctl start -D /usr/local/pgsql/data -l serverlog'

6. 데이터베이스 종료

$ kill -INT `head -1 /usr/local/pgsql/data/postmaster.pid`