💾 Archived View for elmau.net › notes › postgres.gmi captured on 2024-07-09 at 00:01:17. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2023-07-22)

-=-=-=-=-=-=-

Postgres

• 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

Regresar el índice

Regresar el inicio