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