On Mon, Jul 9, 2012 at 1:21 PM, Stuart Bishop <stuart at stuartbishop.net> wrote:
> Anyone seen something like this before?
>
> 2012-07-09 04:48:59 UTC[4137] ERROR  remoteWorkerThread_1: "select
> "_sl".finishTableAfterCopy(20); analyze "public"."reviewsapp_review";
> " PGRES_FATAL_ERROR ERROR:  could not determine which collation to use
> for string comparison
> HINT:  Use the COLLATE clause to set the collation explicitly.
> CONTEXT:  SQL statement "reindex table "public"."reviewsapp_review""
> PL/pgSQL function "finishtableaftercopy" line 27 at EXECUTE statement

I've sorted this.

For the record, I think the sequence of actions to cause this was:
  - Build the db schema on the slave database.
  - Install the debversion package on the slave server, installing its
.so and support files.
  - Attempt to set up slony replication

Those first two steps are obviously the wrong way around, yet I'm
pretty certain no errors were reported so I don't know what happened.
Dropping the new node and dropping the database, recreating it and
resubscribing worked fine.


-- 
Stuart Bishop <stuart at stuartbishop.net>
http://www.stuartbishop.net/