PostgreSQL Installation i luga o Ubuntu 22.04

Faʻapipiʻiina ma le Faʻatonuina o PostgreSQL i luga o Ubuntu 22.04

Faʻatulaga le faitotoʻa o le PostgreSQL database server i luga o le Ubuntu 22.04 ma le faʻatulagaina lelei mo le faʻaaogaina o le gaosiga.

Faʻapipiʻi

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

Faʻatulagaina o le amataga

Faʻatulagaina PostgreSQL e ala i le toe faʻaleleia / etc / postgresql / 14 / main / postgresql.conf:

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

Faʻatonu le faʻafanua

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

Faʻatonuina o le aʻoaʻoga

Faʻatonu shared_buffers i le 25% o le RAM. Faʻaaoga le fesoʻotaʻiga pooling (pgBouncer) mo faʻaoga maualuga-traffic.

Faʻatulagaga o le backup

Faʻaaoga pg_dump mo se backup logical poʻo pg_basebackup mo se backup physical. Faʻatali mo le faʻatulagaina o le stream replication.

Fautuaga mo le saogalemu

• Toe faʻaleleia le poloka pito i luga mai le 5432 i se poloka faʻapitoa
• Faʻatagaina fesoʻotaʻiga SSL/TLS
• Faʻatulagaina o le firewall e faʻatagaina ai IP faapitoa
• Faʻafouga saogalemu masani