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

diedataou profile image

PostgreSQL Fitness: 10 Essential Maintenance Practices for a Healthy Database

Ajit Kumar Jena -

mcadariu profile image

Fixing a slow table join

Mircea Cadariu -

franckpachot profile image

Pessimistic locking, Read Committed, and all Isolation Levels

Franck Pachot -

franckpachot profile image

Unique PostgreSQL-compatible Distributed SQL database

Franck Pachot -