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

Thu Aug 29 15:37:40 UTC 2013

Yes, just use the pg_dump command itself if that works better. The
paster command is just a thin wrapper of pg_dump to save you looking
up the password etc. There most be some weird things going on with the
shell that it runs paster in that fouls up the authentication. In this
case, unless anybody is using it, the paster version might be usefully
deleted.

To load it back into CKAN I use psql, but you may find the paster
version works. FYI here's my command line:

cat backup.pg_dump.gz | gunzip | sudo -u postgres psql $db

David

On 27 August 2013 08:00, Henrik Aagaard Sørensen <BU1G at tmf.kk.dk> wrote:
> Printing out the command_line does show pg_dump being called with -h localhost.
> However, when I copy-paste the command_line output everything works and I do get my SQL dump.
>
> Is this just what db dump does? Can I use the manual pg_dump to import to CKAN?
>
> _______________________________________________
> 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