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

mikeyoung44 profile image

LLMs Under Pressure: How Memory Compression Affects AI Performance

Mike Young -

mikeyoung44 profile image

AI Gets Smarter at Visual Tasks Using Chess-Like Strategy System

Mike Young -

mikeyoung44 profile image

Study: Medium-Sized AI Models Match Larger Ones for Multi-Language Translation When Properly Prompted

Mike Young -

mikeyoung44 profile image

AI Breakthrough: Self-Learning Math Provers Generate and Solve Their Own Theorems

Mike Young -