PostgreSQL version

Status of this page: Very early draft

---

db-opendrr (listed in docker-compose.yml) is built with postgis/Dockerfile from postgis/postgis (i.e. postgis/postgis:latest) on Docker Hub...

• Question: Should we lock it at a specific version so the build is more predictable? Answer: Probably should.

Keeping OpenDRR/python-env (python-opendrr container) up-to-date

To check the current version:

$ docker run -it --rm ghcr.io/opendrr/python-env:1.2.4 /bin/bash
root@7590c28af180:/# pg_dump --version
pg_dump (PostgreSQL) 14.5 (Debian 14.5-1.pgdg110+1)
root@7590c28af180:/# dpkg -l postgresql-client
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name              Version          Architecture Description
+++-=================-================-============-=====================================================
ii  postgresql-client 14+243.pgdg110+1 all          front-end programs for PostgreSQL (supported version)

After replacing 'deb http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main 14' with 'deb http://apt.postgresql.org/pub/repos/apt/ bullseye-pgdg main 15' in OpenDRR/python-env Dockerfile (or in /etc/apt/sources.list.d/pgdg.list inside the container) and upgrading postgresql-client, we get, for example (on 2022-12-29):

# pg_dump --version
pg_dump (PostgreSQL) 15.1 (Debian 15.1-1.pgdg110+1)
# dpkg -l postgresql-client
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name              Version          Architecture Description
+++-=================-================-============-=====================================================
ii  postgresql-client 15+246.pgdg110+1 all          front-end programs for PostgreSQL (supported version)

'ServerManager' object has no attribute 'user_info' error in (older) pgAdmin 4

William (@wkhchow) shared his findings of a new error as seen in pgAdmin 4 on 2022-12-28:

'ServerManager' object has no attribute 'user_info'

• How To Resolve/Fix 'ServerManager' Object Has No Attribute 'user info' In PostgreSQL pgAdmin 4 - YouTube

• [https://stackoverflow.com/questions/69378663/how-can-i-solve-servermanager-object-has-no-attribute-user-info-error-in-pos pgadmin 4 - How can I solve 'ServerManager' object has no attribute 'user_info' error in postgresql pqAdmin - Stack Overflow]

• Version 6.14 release notes - Supports PostgreSQL 14

• Version 6.15 release notes - First version to support PostgreSQL 15

• Version 6.16 release notes - latest version as of December 2022