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 3.1k 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

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.

×
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.
Submit an Answer