DEV Community

Jeevachaithanyan Sivanandan
Jeevachaithanyan Sivanandan

Posted on

restore postgres database in Odoo

#postgres #postgressql #odoo

To restore the database gzip file to a database,

gunzip < backup_database.sql.gzip  | psql -d <db_name>
Enter fullscreen mode Exit fullscreen mode

if you want to restore from .sql file then

psql -d new_database_name -f /path/to/your/sql/file.sql
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

scion01 profile image

Optimizing Pagination in PostgreSQL: OFFSET/LIMIT vs. Keyset

Nishant -

adammetis profile image

VACUUM In Postgres Demystified

Adam Furmanek -

awalias profile image

Prisma + Postgres

awalias -

developpeurtaf profile image

Utilisation de Postman pour les Tests d'API : Un Guide Complet

Fabrice -