Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


how to dump database ,using erppeek api and python script

on 6/15/16, 6:29 AM 348 views

I have created that script to connect with the odoo database using erp peek  i want to dump that database to my local machine .. the script is below

import os

import time

import subprocess

import erppeek

SERVER = 'http://localhost:8069'

client = erppeek.Client(server=SERVER)

print "connection success"

dump_dir = '/var/lib/postgresql/9.3/main'

db_username = ['admin']

db_names = ['ErpPeekDemoDatabase']

for db_name in db_names:


dumper = " -U %s --password -Z 9 -f %s -F c %s "

bkp_file = '%s_%s.sql' % (db_name, time.strftime('%Y%m%d_%H_%M_%S'))

file_path = os.path.join(dump_dir, bkp_file)

command = 'pg_dump' + dumper % (db_username, file_path, db_name)

subprocess.call(command, shell=True)

subprocess.call('gzip ' + file_path, shell=True)

print "backup success"


print "Couldn't backup database" % (db_name)

 i got this error

pg_dump: [archiver (db)] connection to database "ErpPeekDemoDatabase" failed: FATAL: Peer authentication failed for user "[admin]"

backup success

On 6/21/16, 6:44 AM

Check your pg_hba.conf configuration and set necessary permission

# "local" is for Unix domain socket connections only

local all all peer

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 6/15/16, 6:29 AM
Seen: 348 times
Last updated: 6/21/16, 6:44 AM