This question has been flagged
2 Replies
2567 Views

Hi, when I'm using this backup script : https://www.odoo.com/de_DE/forum/how-to/installation-12/how-to-setup-a-regular-postgresql-database-backup-4728

8

Im getting this error:

Stopping odoo: ok

pg_dump: [archiver (db)] connection to database "giordano_init" failed: FATAL: role "root" 

Starting odoo: ok



What am I doing wrong?

Avatar
Discard
Author Best Answer

I fix the issue

pg_dump -U odoo -E UTF-8 -p 5432 -F p -b -f $filename $db


with this command it works! finally

Avatar
Discard

the "-U odoo" makes it work. You have to specify the proper postgres user in order to access the dabase.

Best Answer

Try changing root with postgre and see if it works. 

Avatar
Discard