💾 Archived View for elmau.net › notes › postgres.gmi captured on 2021-12-06 at 14:29:53. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2021-11-30)
-=-=-=-=-=-=-
Instalar
sudo apt install postgresql
Configurar acceso
sudo vim /etc/postgresql/12/main/pg_hba.conf
local all postgres trust
local all all scram-sha-256
sudo systemctl restart postgresql
Crear roles y bases de datos
psql -U postgres
create role ROLE_NAME with login encrypted password 'CONTRASEÑA';
create database NAME with owner ROLE_NAME;