Error when migrating from sqlite to postgresql

[Andrew]

Hi,

I'm new to Trac but after using the MultiRepoSearchPlugin I find that the searches are pretty slow. I'm hoping that switching to a real database will speed up searches (full text indexes, etc).

Attempting to issue a migrate to switch over to postresql gives this error:

Copying tables:
  attachment table... 0 records.
  auth_cookie table... 1 records.
  cache table... 3 records.
  component table... 4 records.
  enum table... 13 records.
  mastertickets table... 0 records.
  milestone table... 0 records.
  node_change table... 9641 records.
  permission table... 30 records.
  report table... 8 records.
  repository table... 8 records.
OperationalError: Could not decode to UTF-8 column 'contents' with text 'OggS'
  repository_node table... 

The same error occurs when attempting to use MySQL as well (which is what I prefer).

-Andrew

[Jun Omae]

That is a MultiRepoSearchPlugin issue. The plugin creates repository_node.contents as TEXT column and stores contents of files in the repositories into the column. The column must be stored utf-8 string cause of TEXT column, not binary. However, the plugin would store the contents without changes to repository_node.contents.