docker-mailman icon indicating copy to clipboard operation
docker-mailman copied to clipboard
verified publisher icon maxking

PostgreSQL 17 not supported

Open outermedia-cbo opened this issue 1 year ago • 4 comments

maxking/mailman-core:0.5 and maxking/mailman-web0.5

With PostgreSQL 17 Mailman does not start:

ERROR: column d.daticulocale does not exist

PostgreSQL 17 needs postgresql17-client. Unfortunately it is only in edge.

You can fix this with:

apk add --upgrade postgresql17-client --repository=https://dl-cdn.alpinelinux.org/alpine/edge/main

I hope this helps, in case someone else has upgraded PostgreSQL to 17.

outermedia-cbo avatar Dec 04 '24 10:12 outermedia-cbo

also just stumbled upon this. using postgresql 14 docker image now until this is natively supported.

domdorn avatar Feb 09 '25 21:02 domdorn

The problem is the docker-entrypoint.sh of mailman-core. The container uses psql in version 15. If you try to make a -l request with an older psql binary, you got this error.

You can "fix" this by changing \l to \d. This request works and the script go on.

TB1234 avatar May 08 '25 09:05 TB1234

You can "fix" this by changing \l to \d. This request works and the script go on.

I guess you are referring to this line? : https://github.com/maxking/docker-mailman/blob/6b091fc17a578437b320c9ae85bfe50d1a616aef/core/docker-entrypoint.sh#L9

SVAneubauer avatar May 08 '25 09:05 SVAneubauer

Yes. This line is the problem.

TB1234 avatar May 08 '25 09:05 TB1234