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

kaustubhyerkade profile image

Maximizing Performance: Best Practices for Database Scaling

kaustubh yerkade -

acetrondi profile image

Using Supabase SMS-Hook to Send Custom Authentication Messages in India

acetrondi -

deni_sugiarto_1a01ad7c3fb profile image

Fixing “Connection Refused” Error Between pgAdmin and Postgres in Docker

Deni Sugiarto -

misachi profile image

Debugging Postgres

Brian Misachi -