MIME-Version: 1.0
From: Paul A Jungwirth <pj@illuminatedcomputing.com>
Date: Wed, 11 Feb 2026 14:39:50 -0800
Message-ID: 
 <CA+renyW-Fc0m3+dp0kGwhHPuhuNbk4x2YZSSx5b8KTfbBbc45w@mail.gmail.com>
Subject: Upgrade some pgweb python dependencies
To: pgsql-www@lists.postgresql.org
Content-Type: multipart/mixed; boundary="00000000000082e5ad064a940d63"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BrenyW-Fc0m3%2Bdp0kGwhHPuhuNbk4x2YZSSx5b8KTfbBbc45w%40mail.gmail.com>
Precedence: bulk

--00000000000082e5ad064a940d63
Content-Type: text/plain; charset="UTF-8"

I submitted a patch to pgarchive recently, which led me to setting up
pgweb, based on the instructions in docs/dev_install.rst.[0]

Using debian 13 and python 3.9, I ran into several errors running `pip
install -r requirements.txt`. The versions pinned there look quite
old. The latest allowed version of pycryptodomex even seems to use
python2 syntax, so I don't understand how it works for anyone else.
Here are some patches with the upgrades I needed to get things
installed and running. (The pycryptodomex failure didn't appear until
I ran `./manage.py migrate`.) The psycopg2 upgrade is very modest, but
the other two are more aggressive. Probably more of the dependencies
are due for upgrading as well, but they do work.

[0] https://www.postgresql.org/message-id/CA%2BrenyWA77wVu2Zis3%3DtdBWAj-Xbz7cKuZbMbo6%3Do5cMR7wZVQ%40mail.gmail.com

Yours,

-- 
Paul              ~{:-)
pj@illuminatedcomputing.com

--00000000000082e5ad064a940d63
Content-Type: text/x-patch; charset="US-ASCII";
	name="v1-0003-Allow-pycryptodomex-up-to-3.23.0.patch"
Content-Disposition: attachment;
	filename="v1-0003-Allow-pycryptodomex-up-to-3.23.0.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mlim3tuf2>
X-Attachment-Id: f_mlim3tuf2

RnJvbSAzN2NmMmRiYmQ2YjQxYzk5MzViNDg4YTk5N2Y4NjIxOWE4NjA0YmJkIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAiUGF1bCBBLiBKdW5nd2lydGgiIDxwakBpbGx1bWluYXRlZGNv
bXB1dGluZy5jb20+CkRhdGU6IFdlZCwgMTEgRmViIDIwMjYgMTQ6MTQ6MjQgLTA4MDAKU3ViamVj
dDogW1BBVENIIHYxIDMvM10gQWxsb3cgcHljcnlwdG9kb21leCB1cCB0byAzLjIzLjAKCk91ciBg
cmVxdWlyZW1lbnRzLnR4dGAgZmlsZSBwaW5zIHB5Y3J5cHRvZG9tZXggdG8gdmVyeSBvbGQgdmVy
c2lvbnM6CgogICAgcHljcnlwdG9kb21leD49My40LjcsPDMuNQoKMy40LjEyIHdhcyByZWxlYXNl
ZCBpbiAyMDE4LiBSdW5uaW5nIGAuL21hbmFnZS5weSBtaWdyYXRlYCBmYWlscyB3aXRoIGEKc3lu
dGF4IGVycm9yLCBiZWNhdXNlIGl0J3MgdXNpbmcgdGhlIG9sZCBQeXRob24gMiBjb21tYSBzeW50
YXggZm9yIGFuCmBleGNlcHRgIGNsYXVzZS4gSSBkb24ndCByZWNhbGwgUHl0aG9uIDMgZXZlciBz
dXBwb3J0aW5nIHRoYXQgc3ludGF4LCBzbwpJJ20gbm90IHN1cmUgaG93IHRoaXMgYHJlcXVpcmVt
ZW50cy50eHRgIGZpbGUgZXZlciB3b3JrZWQgYmVmb3JlLgotLS0KIHJlcXVpcmVtZW50cy50eHQg
fCAyICstCiAxIGZpbGUgY2hhbmdlZCwgMSBpbnNlcnRpb24oKyksIDEgZGVsZXRpb24oLSkKCmRp
ZmYgLS1naXQgYS9yZXF1aXJlbWVudHMudHh0IGIvcmVxdWlyZW1lbnRzLnR4dAppbmRleCA2ZmFi
YTliZS4uZTE3YTc4NzcgMTAwNjQ0Ci0tLSBhL3JlcXVpcmVtZW50cy50eHQKKysrIGIvcmVxdWly
ZW1lbnRzLnR4dApAQCAtMSw2ICsxLDYgQEAKIERqYW5nbz49NC4yLDw0LjMKIHBzeWNvcGcyPT0y
LjguNgotcHljcnlwdG9kb21leD49My40LjcsPDMuNQorcHljcnlwdG9kb21leD49My40LjcsPD0z
LjIzLjAKIE1hcmtkb3duPT0zLjAuMQogcmVxdWVzdHMtb2F1dGhsaWI9PTEuMC4wCiBjdnNzPT0y
LjIKLS0gCjIuNDcuMwoK
--00000000000082e5ad064a940d63
Content-Type: text/x-patch; charset="US-ASCII";
 name="v1-0002-Upgrade-PyYAML-to-6.0.3.patch"
Content-Disposition: attachment;
	filename="v1-0002-Upgrade-PyYAML-to-6.0.3.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mlim3tu41>
X-Attachment-Id: f_mlim3tu41

RnJvbSA5NTE5Y2ViZTY5Zjc0ODJlNGE4N2ZjZmE5ZjA1NDA2YmI2NjBmZTM5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAiUGF1bCBBLiBKdW5nd2lydGgiIDxwakBpbGx1bWluYXRlZGNv
bXB1dGluZy5jb20+CkRhdGU6IFdlZCwgMTEgRmViIDIwMjYgMTM6NTk6MjYgLTA4MDAKU3ViamVj
dDogW1BBVENIIHYxIDIvM10gVXBncmFkZSBQeVlBTUwgdG8gNi4wLjMKClByZXZpb3VzbHkgd2Ug
d2VyZSB1c2luZyAzLjEzLCByZWxlYXNlZCBpbiAyMDE4LiBUaGlzIG5vIGxvbmdlciBidWlsZHMK
b24gRGViaWFuIDEzICh1c2luZyBweXRob24zLjkpLgotLS0KIHJlcXVpcmVtZW50cy50eHQgfCAy
ICstCiAxIGZpbGUgY2hhbmdlZCwgMSBpbnNlcnRpb24oKyksIDEgZGVsZXRpb24oLSkKCmRpZmYg
LS1naXQgYS9yZXF1aXJlbWVudHMudHh0IGIvcmVxdWlyZW1lbnRzLnR4dAppbmRleCA2NDQ2MTA4
Ni4uNmZhYmE5YmUgMTAwNjQ0Ci0tLSBhL3JlcXVpcmVtZW50cy50eHQKKysrIGIvcmVxdWlyZW1l
bnRzLnR4dApAQCAtOSw2ICs5LDYgQEAgcHljb2Rlc3R5bGU9PTIuNC4wCiBweW5saW5lcj09MC44
LjAKIEJhYmVsPT0yLjYuMAogYmxlYWNoPT0zLjEuNAotUHlZQU1MPT0zLjEzCitQeVlBTUw9PTYu
MC4zCiB6c3RhbmRhcmQ9PTAuMjMuMAogcnBtZmlsZT09Mi4xLjAKLS0gCjIuNDcuMwoK
--00000000000082e5ad064a940d63
Content-Type: text/x-patch; charset="US-ASCII";
	name="v1-0001-Upgrade-psycopg2-to-2.8.6.patch"
Content-Disposition: attachment;
	filename="v1-0001-Upgrade-psycopg2-to-2.8.6.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mlim3tts0>
X-Attachment-Id: f_mlim3tts0

RnJvbSA5MzMwODkxMWYwZDQzN2E1NGZmZTE1ZjExYmYyYzNiMDJhZjAyNzA1IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAiUGF1bCBBLiBKdW5nd2lydGgiIDxwakBpbGx1bWluYXRlZGNv
bXB1dGluZy5jb20+CkRhdGU6IFdlZCwgMTEgRmViIDIwMjYgMTM6NTI6MDggLTA4MDAKU3ViamVj
dDogW1BBVENIIHYxIDEvM10gVXBncmFkZSBwc3ljb3BnMiB0byAyLjguNgoKVGhpcyBmaXhlcyBh
biBlcnJvciBpbnN0YWxsaW5nIGl0IG9uIERlYmlhbiAxMyAoYW5kIGVsc2V3aGVyZSkgZGVzY3Jp
YmVkCltpbiB0aGlzIEdpdGh1YiBpc3N1ZV0oaHR0cHM6Ly9naXRodWIuY29tL3BzeWNvcGcvcHN5
Y29wZzIvaXNzdWVzLzEzOTcpLgpUaGV5IGZpeGVkIGl0IGluIFt0aGlzCnB1bGwgcmVxdWVzdF0o
aHR0cHM6Ly9naXRodWIuY29tL3BzeWNvcGcvcHN5Y29wZzIvcHVsbC8xMzk5KS4KLS0tCiByZXF1
aXJlbWVudHMudHh0IHwgMiArLQogMSBmaWxlIGNoYW5nZWQsIDEgaW5zZXJ0aW9uKCspLCAxIGRl
bGV0aW9uKC0pCgpkaWZmIC0tZ2l0IGEvcmVxdWlyZW1lbnRzLnR4dCBiL3JlcXVpcmVtZW50cy50
eHQKaW5kZXggODQwMDM3ZWUuLjY0NDYxMDg2IDEwMDY0NAotLS0gYS9yZXF1aXJlbWVudHMudHh0
CisrKyBiL3JlcXVpcmVtZW50cy50eHQKQEAgLTEsNSArMSw1IEBACiBEamFuZ28+PTQuMiw8NC4z
Ci1wc3ljb3BnMj09Mi44LjUKK3BzeWNvcGcyPT0yLjguNgogcHljcnlwdG9kb21leD49My40Ljcs
PDMuNQogTWFya2Rvd249PTMuMC4xCiByZXF1ZXN0cy1vYXV0aGxpYj09MS4wLjAKLS0gCjIuNDcu
MwoK
--00000000000082e5ad064a940d63--