PostgreSQL Installation ka Ubuntu 22.04

Ho kenya le ho hlophisa PostgreSQL ho Ubuntu 22.04

Sebetsa PostgreSQL database server ka Ubuntu 22.04 le ho hlophisa ho nepahetseng bakeng sa ho sebelisa tlhahiso.

Ho kenya

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

Qt:: Configuration

PostgreSQL ho hlophisa ka ho fetola / etc / postgresql / 14 / main / postgresql.conf:

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

E-ba le tsebo ea ho kenya

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

Ho kenya tšebetsong

E-ba le shared_buffers ho 25% ea RAM. Sebelisa ho kopanya ho kopanya (pgBouncer) bakeng sa li-apps tse nang le li-traffic tse phahameng.

Litsela tsa ho boloka

Senya pg_dump bakeng sa li-backup tsa logical kapa pg_basebackup bakeng sa li-backup tsa physical. E-ba hlokolosi ho beha stream replication.

Litlhahiso tsa Tšireletso

• Tlosa port e tloaelehileng ho tloha ho 5432 ho ea ho port e khethehileng
• Ho lumella ho kopanya SSL/TLS
• Qwalasela firewall ho lumella IP tse itseng feela
• Lintlafatso tsa polokeho