[ckan-dev] Permission denied on _table_metadata

Mon Mar 17 09:13:41 UTC 2014

On 2014-03-17 10:09, Ivan wrote:
> Hi Johann,
>
> try running
>
>    paster datastore set-permissions postgres -c $CKAN_INI_FILE
>

Feeling stupid, it's described here,

http://docs.ckan.org/en/latest/maintaining/datastore.html#set-permissions

now it's working, thank you!

Johann

> --
> Ivan
>
>
> On Monday, 17 March, 2014 at 4:38 pm, Johann Höchtl wrote:
>
>> Hello,
>>
>> I installed CKAN 2.2a from source as described on the online documentation.
>>
>> When I run
>>
>> paster create-test-data -c /file/to/my/config
>>
>> I get the error from sqlalchemy that the user has insufficient rights on
>> the relation _table_metadata. CKAN 2.2 starts up fine, no error messages
>> and the datapusher as well.
>>
>> I already asked the question on
>>
>> http://stackoverflow.com/questions/22449566/ckan-load-test-data-permission-denied-for-table-metadata
>>
>> and it looks similar to
>>
>> https://lists.okfn.org/pipermail/ckan-dev/2012-October/003227.html
>>
>> Please advice. I am short before giving a presentation on CKAN 2.2 new
>> features and some data to click through would be great!!!
>>
>> Greetings, Johann
>>