Ufakelo lwe-PostgreSQL kwi-Ubuntu 22.04

Ukufaka kunye nokumiselwa kwePostgreSQL kwi-Ubuntu 22.04

Misela iseva ye-PostgreSQL kwi-Ubuntu 22.04 ngokumiselwa kwenkqubo efanelekileyo yokusetyenziswa kokwenza imveliso.

Ufakelo

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

Uqwalaselo Lokuqala

Misela inkqubo ye-PostgreSQL ngokuhlela i-/etc/postgresql/14/main/postgresql.conf:

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

Yenza isiseko sedata kunye nomsebenzisi

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

Ulawulo lwe Performance

I-tune i-shared_buffers kwi-25% ye-RAM. Sebenzisa uthungelwano oludityanisiweyo (pgBouncer) kwiinkqubo ezinomthwalo omkhulu.

Inkqubo yovimba weefayili

Sebenzisa i-pg_dump ye-backup eyonwabisayo okanye i-pg_basebackup ye-backup ebonakalayo. Qaphela ukumisela ukuphinda uqhubeke.

Iingcebiso zokhuseleko

• Tshintsha isiqhagamshelanisi esimiselweyo ukusuka kwi 5432 ukuya kwisiqhagamshelanisi esimiselweyo
• Yenza uxhulumaniso lwe-SSL/TLS
• Qwalasela i-firewall ukuze ivumele kuphela ii-IP ezikhankanyiweyo
• Uhlaziyo lokhuseleko oluqhelekileyo