trac postgresql needs to be upgraded

[robe]

I went to check on postgresql running on trac, and discovered it's running

PostgreSQL 9.5.1, that is like 9 patch levels behind latest. Latest 9.5 patchlevel is 9.5.10.

We really should be running 9.5.8 or above.

I did confirm that autovacuum is on, so lack of vacuuming is probably not the issue we are having.

But aside from that I don't have permissions to look at the log files in the /var/lib/postgresql/9.5/main folder. So I'm kinda stuck troubleshooting any other postgresql related issues.

I still feel the issue has to do with that TLS handshake thing that takes forever.

[robe]

It seems I do have sudo access.

[TemptorSent]

I would not recommend doing a blind-update on postgresql, even within the same major.minor version, without at the very least having tested loading a full db dump into an instance of the target pg version on another machine.

[martin]

You didn't describe any issue (aside from "needs to be upgraded"), but I confirm having updated PostgreSQL to 10.2 on the TracSVN VM today.

[robe]

martin,

I was just expecting an upgrade to the latest micro version of 9.5 as upgrading to 10.2 would require pg_upgrade of the dbs to migrate them to 10.2 and I also wasn't sure if that would break some things as there were some 10 changes that broke certain SQL statements.

BTW did something change with trac ssh? I don't seem to be able to ssh into the trac vm anymore with my OSGeo account.

[robe]

Martin,

Wow yippee confirmed all our databases are on postgresql 10.2 now.

I'm going to close this out. But I'll monitor for any breaking things in trac / gitea. At a glance looks good and things feel faster.