Introducing DigitalOcean Functions: A powerful, serverless compute solution

Question

I want backup data postgres openerp base automatic from other server then restore database to my server, but I don't know . help me, thanhk

  • Posted December 10, 2014

I want backup data postgres openerp base automatic from other server then restore database to my server, but I don’t know . help me, thanhk

Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Andrew SB • June 10, 2016

To backup a Postgres database, you can use the pg_dump utility.

sudo -u postgres pg_dump postgres > postgres_db.bak

You can restore it on another server by running:

psql -f postgres_db.bak postgres

Check out this article for a deeper dive into the topic: