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

edvichuki profile image

Working with PostgreSQL Date and Time Functions

Gichuki Edwin -

codingashish_dev profile image

Step-by-Step Guide to Installing PostgreSQL on Arch Linux

Ashish Prajapati -

franckpachot profile image

Aurora Limitless - SQL Limitations

Franck Pachot -

k4ml profile image

PostgreSQL as a Celery Broker

Kamal Mustafa -