Restaurar backup postgres (DBeaver)

  1. Instalar Postgres 17
  2. Crear base de datos
  3. Crear esquema public
  4. Instalar extensión hstore
    CREATE EXTENSION IF NOT EXISTS hstore SCHEMA public;
  5. Restaurar backup con los argumentos --no-owner --no-privileges para no tener problemas de privilegios: 
    /usr/lib/postgresql/17/bin/pg_restore --verbose --host=localhost --port=5435 --username=postgres --no-owner --no-privileges --format=c --dbname=metropolitan_db /home/developer/Documentos/work/gitlab/eRoom/bk-metropolitan-202601091524.sql

Revision #4
Created 2026-01-09 19:48:29 UTC by Jeison Perez
Updated 2026-01-09 20:12:03 UTC by Jeison Perez