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:

try:

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"

except:

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