[ckan-dev] Database dump on Czech CKAN

Fri Sep 16 09:46:01 UTC 2011

Ondrej,

For older CKAN versions like this, simply use 'pg_dump
>cz-ckan.pg_dump' with options according to the database details help
in the cz.ini (sqlalchemy.url).

David

2011/9/16 Ondřej Vadinský <ondrej.vadinsky at vse.cz>:
> Hello,
>
> in order to upgrade CKAN on eu19 (currently on version 1.3.2), I am trying to back up the database. Sugested method ends with some error though:
>
> okfn at eu19:~$ paster --plugin=ckan db dump ./cz-ckan-db-dump --config=/etc/ckan/cz/cz.ini
> /usr/lib/pymodules/python2.6/ckan_deps/sqlalchemy/engine/url.py:105: SADeprecationWarning: The SQLAlchemy PostgreSQL dialect has been renamed
> from 'postgres' to 'postgresql'. The new URL format is postgresql[+driver]://<user>:<pass>@<host>/<dbname>
>  module = __import__('sqlalchemy.dialects.%s' % (dialect, )).dialects
> This functionality is mothballed for now.
>
> How am I supposed to back up the database?
>
> Regards,
>
> Ondřej Vadinský
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
>