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
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('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]"
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
|Asked: 6/15/16, 6:29 AM|
|Seen: 348 times|
|Last updated: 6/21/16, 6:44 AM|