Mail Gateway CT Template on PVE database error?

[JohnnyD]

I am playing with the CT template proxmox-mailgateway-8.0-standard_8.0-1_amd64.tar.zst on PVE which is a container image and seeing the following error in syslog on the gateway.

Sep 05 15:20:23 pmmg4 pg_backupcluster[4240]: pg_receivewal: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL: no pg_hba.conf entry for replication connection from host "[local]", user "postgres", no encryption
Sep 05 15:20:23 pmmg4 pg_backupcluster[4238]: Error: pg_receivewal --cluster=15/main --slot pg_receivewal_service --create-slot --if-not-exists failed with exit code 256
Sep 05 15:20:23 pmmg4 systemd[1]: pg_receivewal@15-main.service: Main process exited, code=exited, status=1/FAILURE
Sep 05 15:20:23 pmmg4 systemd[1]: pg_receivewal@15-main.service: Failed with result 'exit-code'.
Sep 05 15:21:23 pmmg4 systemd[1]: pg_receivewal@15-main.service: Scheduled restart job, restart counter is at 14.
Sep 05 15:21:23 pmmg4 systemd[1]: Stopped pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.
Sep 05 15:21:23 pmmg4 systemd[1]: Starting pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main...
Sep 05 15:21:23 pmmg4 systemd[1]: Started pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.

Does anyone know how I fix it?

 

[Stoiko Ivanov]

That's a glitch in the current PMG 8.0 template and will be fixed in the next release - see :
https://forum.proxmox.com/threads/pmg-behind-npm-not-receiving-any-emails.130704/post-577614

disabling all of the wal-related services should help in the meantime

 

[JohnnyD]

Thanks Stoiko, how long before the next release? If i utilise this one and start configuring into a cluster etc, how do i utilise the new template?

 

[Stoiko Ivanov]

Thanks Stoiko, how long before the next release? If i utilise this one and start configuring into a cluster etc, how do i utilise the new template?

just disable the services - the next template won't have too many changes apart from that.

you can install a fresh PMG with the new template if you want and restore a backup - but else a PVE container-template is not "updateable" to a newer template version (which usually just contains newer packages, or is based on a new major release)

I hope this helps!