Mail Gateway CT Template on PVE database error?

JohnnyD

Member
Mar 4, 2023
71
3
8
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?
 
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?
 
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!
 
  • Like
Reactions: JohnnyD

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!