[ECODP-dev] Question about migrating

Thu Jun 13 14:59:54 UTC 2013

Hi Dimitrios,

If you're using a backup of a 1.7 DB you need to start with a 1.7 instance
and follow the upgrade instructions at the link below.
http://docs.ckan.org/en/ckan-1.8/install-from-source.html#upgrading-a-source-install

I think that the error you're seeing is because you haven't run the paster
command previously supplied to set-up the tables for the search-cloud.

I can't advise on CKAN_Index as that's not one of our utilities.

Best

Darwin

*Darwin Peltan*

*Project Manager  |  skype: darwinp  |  twitter:
@darwin<http://twitter.com/darwin>
*

*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>
|open source data management platform
*

On 13 June 2013 14:17, Dimitrios Mexis <dimitrios.mexis at tenforce.com> wrote:

> The particular message comes now when I click "Data" tab, intentionally
> while still also the index runs.
>
>
> On Thu, Jun 13, 2013 at 3:03 PM, Dimitrios Mexis <
> dimitrios.mexis at tenforce.com> wrote:
>
>> Hello John
>>
>> if we have data in 1,7 database CKAN
>>
>> We had 1.8 db and new instance setup
>> Then we restored the 1.7 backup with pg_restore.
>> Then I run the ckan_reindex utility which calls the paster to reindex the
>> database
>> I see some output like:
>>
>> *ERROR:  relation "search_popular_approved" does not exist at character
>> 34*
>> *STATEMENT:  SELECT search_string, count FROM search_popular_approved;*
>> *ERROR:  relation "search_popular_approved" does not exist at character
>> 34*
>> *STATEMENT:  SELECT search_string, count FROM search_popular_approved;*
>> *ERROR:  relation "search_popular_approved" does not exist at character
>> 34*
>> *STATEMENT:  SELECT search_string, count FROM search_popular_approved;*
>> *ERROR:  relation "search_popular_approved" does not exist at character
>> 34*
>> *STATEMENT:  SELECT search_string, count FROM search_popular_approved;*
>> *LOG:  unexpected EOF on client connection*
>>
>> Is that normal ?
>> [ During the process which still runs from the ps faux , I can see that
>> postgresql indeed receives commands from the connection like "SELECT" ]
>>
>> Is that everything ok, and I just have to wait to finish ?
>>
>> Kind regards
>> Dimitrios
>>
>
>
> _______________________________________________
> Ecodp-dev mailing list
> Ecodp-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ecodp-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130613/09f92c50/attachment.html>