create-postgresql-db.txt

postgresql server yaratish va sozlash


db o'rniga o'zizi database nomini qo'yasiz.
user o'rniga kerakli username.
passwordni ham o'zizga moslab olasiz!


sudo apt update
sudo apt list --upgradable
sudo apt upgrade -y
sudo apt install libpq-dev postgresql postgresql-contrib -y
sudo -i -u postgres psql

CREATE DATABASE db;
CREATE USER user WITH PASSWORD 'pass';
ALTER ROLE user SET client_encoding TO 'utf8';
ALTER ROLE user SET default_transaction_isolation TO 'read committed';
ALTER ROLE user SET timezone TO 'UTC';
GRANT ALL PRIVILEGES ON DATABASE db TO user;

\l

GRANT ALL PRIVILEGES ON SCHEMA public TO user;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO user;
\q
sudo nano /etc/postgresql/16/main/postgresql.conf liste_host

server uchun 5432 port ochib qoyish esdan chiqmasin!


agar permission xatolik bersa?
ALTER USER <user_name> WITH SUPERUSER;