Ukufakelwa kwePostgreSQL ku-Ubuntu 22.04

Ukufakela nokuhlela iPostgreSQL ku-Ubuntu 22.04

Sebenzisa i-PostgreSQL database server ku-Ubuntu 22.04 nge-configuration engcono kakhulu yokusetshenziswa kokukhiqizwa.

Ukufakela

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

Ukumiswa kokuqala

Misa i-PostgreSQL ngokuhlela /etc/postgresql/14/main/postgresql.conf:

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

Dala i-database nomsebenzisi

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

Ukuthuthukiswa kwemisebenzi

I-tune shared_buffers ku-25% ye-RAM. Sebenzisa ukuxhuma okuhlanganisiwe (pgBouncer) izisebenziso ezihamba phambili.

Uhlelo lokulondoloza

Sebenzisa i-pg_dump nge-backup efanele noma i-pg_basebackup nge-backup ebonakalayo. Qaphela ukuhlela ukudluliswa kokuziphinda.

Izincomo zokuphepha

• Tshintsha isixhumi esizenzakalelayo kusuka ku-5432 kuya ku-isiqhingi esizenzakalelayo
• Vumela ukuxhumana kwe-SSL/TLS
• Misa i-firewall ukuze ivumele kuphela IPs ezicacisiwe
• Ukuhlaziywa kokuphepha okujwayelekile