[ckan-dev] Empty CKAN Database

Thu Nov 21 14:07:24 UTC 2013

I don't want to mess with the database but I still believe that  
something like this would be very useful if it's possible to be  
implemented in a future release.

Best,

G.

> I don't know of any out of the box way to do this.
>
> You could perhaps try to save the details of the users from the user_list
> API endpoint, empty and re-initialize the database, and then use those
> details to re-create the users. Remember to request this as sysadmin so you
> can get all the details of the users (especially email). You would still
> need to have your users request password resets though.
>
> Otherwise, just try to save the tables from postgresql with pg_dump. You
> can specify table names for pg_dump. I'm not sure if that would cause other
> problems though.
>
>
> Nigel Babu
>
> Developer  |  @nigelbabu <https://twitter.com/nigelbabu>
>
> The Open Knowledge Foundation <http://okfn.org/>
>
> Empowering through Open Knowledge
>
> http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
> Facebook<https://www.facebook.com/OKFNetwork> |
> Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>
>
>  CKAN | http://ckan.org/ | @CKANproject
> <http://twitter.com/CKANproject> |the world’s leading open-source data
> portal platform
>
>
> On 20 November 2013 13:32, Dimitrakakis Georgios <giorgis at ucnet.uoc.gr>wrote:
>
>> Hi!
>>
>> I would like to know if there is a way through paster or something
>> different to empty the CKAN database from all the groups, organizations and
>> datasets (including the private ones) but leave the users intact.
>>
>> I do not want to empty and re-initialize the database! I just want to
>> empty everything and leave the users so that the can start adding
>> information from scratch.
>>
>> Best,
>>
>> G.
>>
>> ----------------------------------------------------------------
>> This message was sent using IMP, the Internet Messaging Program.
>>
>> _______________________________________________
>> 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
>>
>

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.