# Metropolitan APP

# Realizar backup (DBeaver)

1. Instalar **Postgres 17**
2. Configuración para generar backup desde DBeaver  
    [![image.png](https://books.jacidi.com/uploads/images/gallery/2026-01/scaled-1680-/image.png)](https://books.jacidi.com/uploads/images/gallery/2026-01/image.png)

# Restaurar backup postgres (DBeaver)

1. Instalar **Postgres 17**
2. Crear base de datos
3. Crear esquema **public**
4. Instalar extensión **hstore**: ```sql
    CREATE EXTENSION IF NOT EXISTS hstore SCHEMA public;
    ```
5. Restaurar backup con los argumentos **--no-owner** **--no-privileges** para no tener problemas de privilegios: ```bash
    /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
    ```