On Mon, Jul 9, 2012 at 1:21 PM, Stuart Bishop <[email protected]> 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 <[email protected]> http://www.stuartbishop.net/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
