[Qgis-user] What is postgresql client version and does it have anything to do with different postgresql versions

[Groene Bij]

Thank for your reply and the links.

 

I use win10 as OS. On my current pc I use postgresql11 and postgis 2.5.

I am however replacing both my pc and laptop for new equipment, so that got me thinking on maybe upgrading to postgresql12 and postgis 3.1 as well.

Hence my search for information on dependencies and whether QGIS 3.16  (or later) favors any postgresql and postgis version above another

 

Nyall Dawson pointed out the postgresql client version used in qgis is unrelated to postgresql versioning, if I understand him correctly.

 

 

 

Jeroen Hovens

 

 

 

 

 

Van: chris hermansen <clhermansen at gmail.com> 
Verzonden: dinsdag 2 februari 2021 23:00
Aan: Groene Bij <mail at groenebij.nl>
CC: qgis-user <qgis-user at lists.osgeo.org>
Onderwerp: Re: [Qgis-user] What is postgresql client version and does it have anything to do with different postgresql versions

 

Jeroen and list,

 

On Tue, Feb 2, 2021 at 12:37 PM Groene Bij <mail at groenebij.nl <mailto:mail at groenebij.nl> > wrote:

Hi list,

 

PostgreSQL has this interesting versioning where they try to keep like 5 main branches up to date.

At this point you can choose any version from 9.6.x up to 13.x

Also, PostGIS is now slowly but probably steadily moving from 2.5.x to 3.1.x

 

So, setting up a new PostgreSQL database environment  makes me wonder which one to choose.

Since I will only be using this database with QGIS and QGIS 3.16 becoming the new LTR, does QGIS favor one of the PostgreSQL and PostGIS version above another?

 

I did notice in the info screen for qgis3.16.3 it says PostgreSQL Client version 11.5

Does that mean QGIS3.16 might work best with PostgreSQL 11.x? Or are they completely unrelated?

 

What O/S do you use?  I ask because if it's Linux of some sort, your repositories may be a good indicator.

 

This is worth a quick look https://www.postgresql.org/developer/roadmap/

 

Also this https://www.postgresql.org/support/versioning/



-- 

Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210203/bba8d2a9/attachment.html>