Odoo Server (MOVED TO GITHUB)

Backup and Restore

Asked by Girish Sharma

How to take back of Postgre sql 8.3 and Restore.

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
digitalsatori(Shine IT)
Solved:
Last query:
Last reply:
Revision history for this message
Best digitalsatori(Shine IT) (digitalsatori) said : 		#1

Hi Girish Sharma:

OpenERP provides a very easy way to back up a database and restore it
into a new or existing instance of OpenERP. When you connect OpenERP
server with a browser, you will find a "manage database" link at the
bottom of the login page. Or, if you connect OpenERP server through GTK
client , you will find the similar database management tool under
"FILE-DATABASES" menu.

However, the aforementioned tools are provided at client side. Unless
your client is running at the same box as of OpenERP server or the
database is pretty small or you have a very fast connection with the
OpenERP server, the tool provided became not that practical. As
OpenERP's database is simply a postgresql database, you may use any
postgresql database management tools to backup or restore the database,
such as GUI tool like PGAdmin or command line tools like pgdump and
psql. If you dig deep enough, you will also find more advanced topics
like "Continuous Archiving and Point-In-Time Recovery (PITR)" of PostgreSQL.

you will find all the information related with PostgreSQL backup and
restore here: http://www.postgresql.org/docs/8.3/static/backup.html

<http://www.openerp.cn>

*Tony Gu* --Shine IT-- Shanghai, China
Tel : + 86 21 66044468
Cell: + 86 13386068213 Skype: digitalsatori
http://www.openerp.cn
*OpenERP Official Partner in China*

On 2012年06月23日 14:46, Girish Sharma wrote:
> New question #201238 on OpenERP Addons:
> https://answers.launchpad.net/openobject-addons/+question/201238
>
> How to take back of Postgre sql 8.3 and Restore.
>
>
>

Revision history for this message
Ferdinand (office-chricar) said : 		#2

please keep in mind that you have to backup/migrate attachments which are stored externally in a directory called filestore or similar, manually.

Revision history for this message
Girish Sharma (girish-sha) said : 		#3

Thanks digitalsatori, that solved my question.

Revision history for this message
Numérigraphe (numerigraphe) said : 		#4

The answers provided here look pretty comprehensive, so I filed them as new FAQ.
FAQ #1988: “How do I backup and restore OpenERP databases?”.

Revision history for this message
Numérigraphe (numerigraphe) said : 		#5

Dear Girish Sharma,
Please don't overwrite your initial question with a new one. Keeping the questions and answers readable is vital to our "documentation" effort.
But of course you can file another new question anytime you want!
Lionel Sausin.

Revision history for this message
nickbotroyde36 (dyn25stockwell) said : 		#6

Make use of http://www.recoverytoolbox.com/sql.html recovers damaged .mdf files after using unstable software, hard drive fails, system errors.