I've just noticed that when the database backend of the second controller is activated (after the first controller is activated) the encoding of the database is different. The initial database is LATIN1, but when the second controller creates the database and restores the dump, it creates it as UTF8, as shown in the logs:
INFO backup.backupers.NativeCommandExec Starting execution of "createdb -h controller2 -p 5432 -U postgres ssnen_live" INFO backup.backupers.NativeCommandExec Command "createdb -h controller2 -p 5432 -U postgres ssnen_live" logged 0 errors and terminated with exitcode 0 INFO backup.backupers.NativeCommandExec Starting execution of "pg_restore -h controller2 -p 5432 -U postgres --format=c -d ssnen_live /tmp/180707_2 ssnen_live" INFO backup.backupers.NativeCommandExec Command "pg_restore -h controller2 -p 5432 -U postgres --format=c -d ssnen_live /tmp/180707_2 ssnen_live" logged 0 errors and terminated with exitcode 0 as it doesn't seem to specify the encoding anywhere. I'm just wondering if that is the cause of some of my problems and how I would get the second controller to create the db with the correct encoding? Thanks John _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
