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

December 10, 2014 3k views
binhdinhjscpc
By:
binhdinhjscpc

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

Log In to Comment
1 Answer
asb MOD 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:

How To Backup PostgreSQL Databases on an Ubuntu VPS
by Justin Ellingwood
PostgreSQL is a popular database management system that can be used to handle the data from your website or application. This article will discuss methods of backing up PostgreSQL databases to ensure that your information will not be lost in the event of a problem.
Reply
Have another answer? Share your knowledge.