Ferikgong 27, 2026Dikaelo

Jaanong o ka Tsenya PostgreSQL mo Linux Serbereng

Tlhaloso e e feletseng ka go tsenya, go rulaganya, le go sireletsa PostgreSQL database server mo Ubuntu le CentOS.

PostgreSQL ke tsamaiso e e nonofileng, e e bulegileng ya go laola database e e amanang e e itseweng ka go ikanyega, go nna le ditiro tse dintsi, le go latela ditsamaiso. Tlhaloso eno e tla go thusa go tsenya le go rulaganya PostgreSQL mo serbereng sa gago sa Hiddence Linux.

Go Tsenya PostgreSQL mo Ubuntu/Debian

PostgreSQL e gona mo di-repository tse di tlwaelegileng. Tsenya mofuta o o sa tlang:

bash

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

# Simolola le go nolofatsa PostgreSQL
sudo systemctl start postgresql
sudo systemctl enable postgresql

# Nnetefatsa tsenyo
sudo systemctl status postgresql
psql --version

Go Tsenya PostgreSQL mo RHEL / CentOS / AlmaLinux / Rocky Linux

Bakeng sa ditsamaiso tse di theilweng mo RHEL, o tshwanetse go tsenya PostgreSQL repository pele:

bash

# Tsenya PostgreSQL repository
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Bakeng sa CentOS 8/Rocky Linux 8, dirisa:
# sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Tsenya PostgreSQL
sudo dnf install -y postgresql15-server postgresql15

# Simolola database
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb

# Simolola le go nolofatsa PostgreSQL
sudo systemctl start postgresql-15
sudo systemctl enable postgresql-15

# Nnetefatsa tsenyo
sudo systemctl status postgresql-15
psql --version

Go Nnetefatsa Tsenyo

bash

# Sekaseka boemo jwa PostgreSQL
sudo systemctl status postgresql

# Sekaseka mofuta wa PostgreSQL
psql --version

# Ikopanye le PostgreSQL (Ubuntu/Debian)
sudo -u postgres psql

# Ikopanye le PostgreSQL (CentOS/RHEL)
sudo -u postgres psql -d postgres

Go Sireletsa PostgreSQL

Bea password bakeng sa modirisi wa postgres:

bash

# Ikopanye le PostgreSQL
sudo -u postgres psql

# Bea password bakeng sa modirisi wa postgres
ALTER USER postgres PASSWORD 'password_ya_gago_e_e nonofileng';

# Tswa mo PostgreSQL
\q

Go Tlhama Database le Modirisi

bash

# Ikopanye jaaka modirisi wa postgres
sudo -u postgres psql

# Tlhama database
CREATE DATABASE myapp_db;

# Tlhama modirisi
CREATE USER app_user WITH PASSWORD 'password_e_e_nonofileng';

# Naya ditokelo
GRANT ALL PRIVILEGES ON DATABASE myapp_db TO app_user;

# Tswa
\q

Go Laola Badirisi

bash

# Ikopanye le PostgreSQL
sudo -u postgres psql

# Lela badirisi botlhe
\du

# Tlhama modirisi o mosha
CREATE USER newuser WITH PASSWORD 'password';

# Naya ditokelo
GRANT ALL PRIVILEGES ON DATABASE myapp_db TO newuser;

# Ntsha ditokelo
REVOKE ALL PRIVILEGES ON DATABASE myapp_db FROM newuser;

# Tlosa modirisi
DROP USER newuser;

Go Nolofatsa Dikopanyo tse di Kwa Kgakala

Go letlelela dikopanyo tse di kwa kgakala, fetola difaele tsa go rulaganya tsa PostgreSQL:

bash

# Fetola pg_hba.conf (Ubuntu/Debian)
sudo nano /etc/postgresql/15/main/pg_hba.conf

# Fetola pg_hba.conf (CentOS/RHEL)
sudo nano /var/lib/pgsql/15/data/pg_hba.conf

# Tsenya mola:
host    all             all             0.0.0.0/0               md5

# Fetola postgresql.conf (Ubuntu/Debian)
sudo nano /etc/postgresql/15/main/postgresql.conf

# Fetola postgresql.conf (CentOS/RHEL)
sudo nano /var/lib/pgsql/15/data/postgresql.conf

# Fetola:
listen_addresses = '*'

# Simolola gape PostgreSQL
sudo systemctl restart postgresql

Ditaelo tsa Motlha tsa PostgreSQL

bash

# Ikopanye le database
psql -U app_user -d myapp_db

# Lela databases
\l

# Ikopanye le database
\c database_name

# Lela ditafole
\dt

# Tlhalosa tafole
\d table_name

# Dira faele ya SQL
psql -U app_user -d myapp_db -f script.sql

# Dirisa backup ya database
pg_dump -U app_user myapp_db > backup.sql

# Busetsa database
psql -U app_user -d myapp_db < backup.sql

Dikgakololo tse di Botlhokwa

Ka metlha dirisa dipassword tse di nonofileng bakeng sa badirisi ba database
Thibela go fitlhela kwa kgakala go di-IP address tse di itseng mo pg_hba.conf
Ka metlha dirisa backup ya databases tsa gago ka go dirisa pg_dump
Lokela di-logs tsa PostgreSQL: /var/log/postgresql/ (Ubuntu) kgotsa /var/lib/pgsql/15/data/log/ (CentOS)
Dirisa connection pooling (pgBouncer) bakeng sa di-application tse di nang le traffic e e kwa godimo
Boloka PostgreSQL e e ntsha mofuta o o ikanyegang o o sa tlang bakeng sa di-patch tsa tshireletso