Cài đặt PostgreSQL database trên Oracle Linux 7

Trong bài này chúng ta sẽ cùng đi cài đặt Postgres Database trên Oracle Linux 7.

Cài đặt Oracle Linux trên VirtualBox: https://datalinks.vn/huong-dan-cai-dat-oracle-linux-7-9-tren-vtbox/

Môi trường cài đặt:

OS: Oracle Linux 7.9

VTBOX 7

Hostname: srv1.localdomain

IP: 192.168.68.11

Phiên bản Postgres cài đặt: 15

Bật Oracle linux và ssh vào thực hiện chạy lệnh sau: (login với user root)

cat /etc/oracle-release

yum update -y

sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

sudo yum install -y postgresql15-server

sudo /usr/pgsql-15/bin/postgresql-15-setup initdb

sudo systemctl enable postgresql-15

sudo systemctl start postgresql-15

Kiểm tra Status DB:

systemctl status postgresql-15.service

Như vậy là Postgres chạy thành công.

Quản trị service: (bật, tắt, xem status…)

systemctl stop postgresql-15.service

systemctl status postgresql-15.service

systemctl start postgresql-15.service

[root@srv1 ~]# systemctl status postgresql-15.service

● postgresql-15.service – PostgreSQL 15 database server

Loaded: loaded (/usr/lib/systemd/system/postgresql-15.service; enabled; vendor preset: disabled)

Active: inactive (dead) since Sun 2024-05-12 18:51:08 +07; 21s ago

Docs: https://www.postgresql.org/docs/15/static/

Process: 6345 ExecStart=/usr/pgsql-15/bin/postmaster -D ${PGDATA} (code=exited, status=0/SUCCESS)

Process: 6336 ExecStartPre=/usr/pgsql-15/bin/postgresql-15-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Main PID: 6345 (code=exited, status=0/SUCCESS)

May 12 18:38:07 srv1.localdomain systemd[1]: Starting PostgreSQL 15 database server…

May 12 18:38:07 srv1.localdomain postmaster[6345]: 2024-05-12 18:38:07.474 +07 [6345] LOG: redirecting log output to logging collector process

May 12 18:38:07 srv1.localdomain postmaster[6345]: 2024-05-12 18:38:07.474 +07 [6345] HINT: Future log output will appear in directory “log”.

May 12 18:38:07 srv1.localdomain systemd[1]: Started PostgreSQL 15 database server.

May 12 18:51:08 srv1.localdomain systemd[1]: Stopping PostgreSQL 15 database server…

May 12 18:51:08 srv1.localdomain systemd[1]: Stopped PostgreSQL 15 database server.

[root@srv1 ~]# systemctl start postgresql-15.service

[root@srv1 ~]# systemctl status postgresql-15.service

● postgresql-15.service – PostgreSQL 15 database server

Loaded: loaded (/usr/lib/systemd/system/postgresql-15.service; enabled; vendor preset: disabled)

Active: active (running) since Sun 2024-05-12 18:51:45 +07; 4s ago

Docs: https://www.postgresql.org/docs/15/static/

Process: 11994 ExecStartPre=/usr/pgsql-15/bin/postgresql-15-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)

Main PID: 12001 (postmaster)

Tasks: 7

CGroup: /system.slice/postgresql-15.service

├─12001 /usr/pgsql-15/bin/postmaster -D /var/lib/pgsql/15/data/

├─12004 postgres: logger

├─12005 postgres: checkpointer

├─12006 postgres: background writer

├─12008 postgres: walwriter

├─12009 postgres: autovacuum launcher

└─12010 postgres: logical replication launcher

May 12 18:51:45 srv1.localdomain systemd[1]: Starting PostgreSQL 15 database server…

May 12 18:51:45 srv1.localdomain postmaster[12001]: 2024-05-12 18:51:45.251 +07 [12001] LOG: redirecting log output to logging collector process

May 12 18:51:45 srv1.localdomain postmaster[12001]: 2024-05-12 18:51:45.251 +07 [12001] HINT: Future log output will appear in directory “log”.

May 12 18:51:45 srv1.localdomain systemd[1]: Started PostgreSQL 15 database server.

Đăng nhập vào Postgres:

su - postgres

psql

select version();

du

dv

postgres=# select version();

version

———————————————————————————————————

PostgreSQL 15.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

(1 row)

postgres=# du

List of roles

Role name | Attributes | Member of

———–+————————————————————+———–

postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

Chúc các bạn thành công.