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.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

Add a comment
binhdinhjscpc
By:
binhdinhjscpc

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
asb 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 Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help