-- Leo's gemini proxy
-- Connecting to elmau.net:1965...
-- Connected
-- Sending request
-- Meta line: 20 text/gemini
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;
Generar respaldo de una base de datos.
pg_dump -U postgres -d DATA_BASE -Fc -f NAME.bk
Restaurar base de datos desde respaldo.
pg_restore -U postgres -d DATA_BASE NAME.bk
-- Response ended
-- Page fetched on Thu May 9 01:13:05 2024