OK, so I have an operational Confluence server, running on database(psql) abcd;
I ran this command to copy it;
CREATE DATABASE abcd_19_dec_19 WITH TEMPLATE abcd OWNER dbowner;
I ran an automated upgrade with a response.varfile to facilitate rapidity, but when I visit my confluence server it now reports {
Database: The database collation 'C' is not supported by Confluence. We recommend utf-8. On Windows you can also use the Windows-1252 collation for your locale.
}
When I run \l+ it shows encoding of UTF8, but also collate of 'C', which worked perfectly for 6.12.1, so I need to know if my db is no longer compatible with Confluence, or if there is additional configuration that my server requires;
abcd | abcdowner | UTF8 | C | C | dbowner | 1000MB | pg_default | This is my vanilla db