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

Fri Aug 23 16:13:31 UTC 2013

The 'sudo' is a bit fishy since it is generally 'sudo -u postgres' for
postgres things like this. However I suggest that in lib/cli.py in the
_run_cmd method you 'print command_line' and debug that. A common
problem tends to be to do with the difference between specifying the
host as localhost or not specifying it at all.

David

On 23 August 2013 12:55, Henrik Aagaard Sørensen <BU1G at tmf.kk.dk> wrote:
> 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?
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>