Odoo Help


How can i take back of Database by Terminal.

on 5/3/16, 1:28 AM 1,836 views


Anyone knows how to take back of database by terminal. I need to take database backup of my server, by terminal.Is there is any  commands that is used for take backup from server. I searched lot, and i tried those what i got , but its not succeed.Could you please help me to do this?

thanking you,


--Ahmed M.Elmubarak--

Ahmed M.Elmubarak
On 5/3/16, 1:50 AM


You can also have an eye on this question it may helps

@ahmed : i already seen this sh script , i don't want use script because i doesn't have experience with scripting .

on 5/3/16, 1:59 AM

You don't need to use the all script. E.g you can use: pg_dump -E UTF-8 -p 5433 -F p -b -f $filename $db to execute the dumping ... $filename is where you will put the dump and $db is your database name ...

Ahmed M.Elmubarak
on 5/3/16, 2:14 AM

@ahmed :- Thank you i will try...

on 5/3/16, 2:46 AM
Krupesh Laiya
On 5/6/16, 4:58 AM


pg_dump dbname | gzip > filename.gz

Reload with

createdb dbname

gunzip -c filename.gz | psql dbname

or you can refer link: http://www.postgresql.org/docs/8.1/static/backup.html

Olalekan Babawale
On 5/6/16, 5:41 AM


A. To backup your database

    1. switch to postgres user

    sudo su - postgres

    2. backup with the ff command;

    pg_dump db_name > db_backup.sql

     [note db_name is the name of the database you want to backup; db_backup.sqlis the name you want to give your backup. Whatever name you want to give to your backup, end it with the .sql extension]

    3. To get the location of your backup, run this command from the terminal

    find / -name db_backup.sql


    1. If your database is on a remote computer, connect to it using WinSCP;  supply your username and password

    2. browse to the directory where your backup is saved as gotten in step 3 of A above

     3. you can then copy the sql file to your desired location or download to a location on your local computer in case it is on         a remote computer.

I hope this helps a lot.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 5/3/16, 1:28 AM
Seen: 1836 times
Last updated: 3/27/18, 11:19 AM