PostgreSQL rakibidda Ubuntu 22.04

Ku rakibidda iyo qaabeynta PostgreSQL on Ubuntu 22.04

Ku dhis server PostgreSQL database on Ubuntu 22.04 oo leh qaabeynta ugu fiican ee isticmaalka wax soo saarka.

Ku rakibidda

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

Asturnaanta Aasaasiga ah

Configure PostgreSQL by edit / etc / postgresql / 14 / main / postgresql.conf:

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

abuuro database iyo user

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

Nidaamka

Tune shared_buffers in 25% ee RAM. U isticmaal xiriirka isku darka (pgBouncer) si ay u codsiyada sare-traffic.

Qorshaha Lacag-dhimista

isticmaal pg_dump ee backups logical ama pg_basebackup ee backups jirka. ka fikir dhismaha streaming isku-dhafka.

Tallaabooyinka Amniga

• Isbedelka isha default ka 5432 in isha custom
• Ka dhig xiriirada SSL/TLS
• Configure firewall si ay u oggolaadaan oo keliya IPs gaar ah
• Isbedelada amniga ee joogtada ah