#2109: trac postgresql needs to be upgraded
---------------------------+-----------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Keywords:
---------------------------+-----------------------
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2109: trac postgresql needs to be upgraded
---------------------------+------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by robe):
It seems I do have sudo access.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109#comment:1>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2109: trac postgresql needs to be upgraded
---------------------------+------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109#comment:2>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2109: trac postgresql needs to be upgraded
---------------------------+------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109#comment:3>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2109: trac postgresql needs to be upgraded
---------------------------+------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: new
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+------------------------
Comment (by 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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109#comment:4>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.
#2109: trac postgresql needs to be upgraded
---------------------------+------------------------
Reporter: robe | Owner: sac@…
Type: task | Status: closed
Priority: normal | Milestone: Unplanned
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+------------------------
Changes (by robe):
* status: new => closed
* resolution: => fixed
Comment:
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.
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2109#comment:5>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.