Nwụnye PostgreSQL na Ubuntu 22.04

Nwụnye na ntọala PostgreSQL na Ubuntu 22.04

Nhazi PostgreSQL database sava na Ubuntu 22.04 na nhazi nke ọma maka iji mmepe.

Nhazi

sudo apt update
sudo apt install postgresql postgresql-contrib -y

Nhazi nhazi mbụ

Nhazi PostgreSQL site n'ịgbanwe /etc/postgresql/14/main/postgresql.conf:

max_connections = 200
shared_buffers = 256MB
effective_cache_size = 1GB
work_mem = 4MB

Kewapụta database na onyenhọrọ

sudo -u postgres psql
CREATE DATABASE myapp;
CREATE USER myuser WITH PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE myapp TO myuser;

Nhazi

Tinye shared_buffers ka 25% nke RAM. Jiri njikọ n'obere (pgBouncer) maka usoroiheomume na-akpụgharị elu.

Nhazi nchekwa

Jiri pg_dump maka ebemkpofuozi logical mọọbụ pg_basebackup maka ebemkpofuozi physical. Nwere ike ịhazi mmegharị n'imegharị.

Ndụmọdụ nchekwa

• Gbanye difọ́ọ̀ltụ̀ port site na 5432 gaa na port emeredịkachọrọ
• Mepee njikọ SSL/TLS
• Nhazie faịrwal ahụ ka ọ nye ikike na IPs emeredịkachọrọ
• Nhazi nke nchekwa