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 1.3k views

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

1 Answer

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:

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.
Have another answer? Share your knowledge.