best PostgreSQL version?

[Mick Fox]

Is there a most supported / compatible / recommended version of PostgreSQL for XNAT 1.8?

I'd guess that 12 would be best, with new features and the longest away end-of-life date, but really the only feature I care about in PostgreSQL on this machine is easy inter-operability with XNAT.

Backstory, I messed up the upgrade from 9 to 10 on a XNAT test machine with no real data and plan on completely uninstalling the old versions of PostgreSQL before trying to install it again.

 

Thanks,

-Mick

[KRANTHI THEJ]

I'm using PostgreSQL 12.2 (XNAT 1.8.2, docker installation)

and it works fine :)

good luck

Kranthi

[Viktor Wottschel]

I had problems with the JDBC driver in version 13 on CentOS 8.

Everything installed fine, tomcat and postgres were running but XNAT didn't start up due to some JDBC library issues.

In the end, I 'downgraded' to version 12 and everything started working like a treat.

On Tuesday, September 14, 2021 at 5:14:23 PM UTC+2 mic...@gmail.com wrote:

[Herrick, Rick]

Yes, I’d say the latest version of PostgreSQL 12 is the best choice at this point. I’ve run with that extensively without issue. PostgreSQL 13 final release wasn’t available at the time we initially released 1.8, so we haven’t tried working with that yet. I was actually just looking at the versions of many of our basic dependencies like the PostgreSQL JDBC driver and plan to try updating those and testing for compatibility over the next few months, but wouldn’t recommend doing anything like that for something that you’re planning on putting into production within the next 6 months or so.

 

-- 

Rick Herrick

XNAT Architect/Developer

Computational Imaging Laboratory

Washington University School of Medicine

 

 

From: xnat_di...@googlegroups.com <xnat_di...@googlegroups.com> on behalf of Viktor Wottschel <viktor.w...@gmail.com>
Date: Thursday, September 16, 2021 at 9:24 AM
To: xnat_discussion <xnat_di...@googlegroups.com>
Subject: [XNAT Discussion] Re: best PostgreSQL version?

* External Email - Caution *

--
You received this message because you are subscribed to the Google Groups "xnat_discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xnat_discussi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/xnat_discussion/2b281e80-32cd-4a32-bb3a-a25e62810703n%40googlegroups.com.

 

---

The materials in this message are private and may contain Protected Healthcare Information or other information of a sensitive nature. If you are not the intended recipient, be advised that any unauthorized use, disclosure, copying or the taking of any action in reliance on the contents of this information is strictly prohibited. If you have received this email in error, please immediately notify the sender via telephone or return mail.