Kukhazikitsa kwa PostgreSQL pa Ubuntu 22.04

Kukhazikitsa ndi kukhazikitsa PostgreSQL pa Ubuntu 22.04

Kukhazikitsa PostgreSQL database server pa Ubuntu 22.04 ndi kuwongolera bwino kwa ntchito yopanga.

Kukhazikitsa

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

Kusintha Kwanthawi Yoyamba

Kusintha PostgreSQL ndi kusintha / etc / postgresql / 14 / main / postgresql.conf:

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

Kukhazikitsa Database ndi User

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

Kuchita bwino

Sinthani shared_buffers kuti 25% ya RAM. Mutha kugwiritsa ntchito kulumikizana kwa magulu (pgBouncer) kwa ntchito zokhala ndi maulendo ambiri.

Backup Strategy

Kugwiritsa ntchito pg_dump kwa zosunga zobwezeretsera lojika kapena pg_basebackup kwa zosunga zobwezeretsera zanyama.

Malamulo achitetezo

• Sinthani default port kuchokera 5432 kuti makonda port
• Kukhazikitsa kugwirizana kwa SSL/TLS
• Kusintha kwa firewall kuti ilole IPs zokha
• Kusintha kwachitetezo chosasintha