[ckan-dev] db dump fails due to password authentication.

[Henrik Aagaard Sørensen]

I'm trying to create a db dump for backup, however, it fails due to password authentication:
sudo /usr/lib/ckan/default/bin/paster --plugin=ckan db dump -c /etc/ckan/default/production.ini my_database_dump.sql
pg_dump: [archiver (db)] connection to database "ckan_default" failed: FATAL:  password authentication failed for user "ckan_default"

The CKAN installation runs fine and the password and username in production.ini is correct.

Any idea what goes wrong?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130823/53897a94/attachment.html>