@Jeannine Gentleman, yes... you definitely want to update your database. PostgreSQL 8 is pretty old. Since you've gotten to Jira 7.9.2, you'll probably want to go all the way to 9.6.x so you won't have to go through this for a while.
The unsupported collation is also a bit of a Big Deal; for the most part (from what I gather) things work well until they... don't... and then it usually ends in tears.
Also, when migrating, I'd suggest that you dump your database but do NOT add the "drop database" and "create database" options to the dump. Rather:
- Create the empty database with correct collations
- Restore into the new empty database
For reference the SQL statements I use routinely when creating the database are:
CREATE ROLE jira;
ALTER ROLE jira LOGIN;
ALTER ROLE jira PASSWORD 'jira';
GRANT jira TO postgres;
CREATE DATABASE jira WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0 OWNER jira;
GRANT ALL ON DATABASE jira TO jira;
Note: the "GRANT jira to postgres" is an AWS RDS thingy; it won't hurt on a local DB but when doing all these steps as user "postgres" on RDS, it fails without that step. If you're running a local instance of PostgreSQL you don't need that step
Also, while they don't "officially" support them, I do take the time to load the latest JDBC drivers from PostgreSQL as I have found some significant performance improvements there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.