Hello,
Today I noticed that my PMG is not receiving mail any more. The log is showing showing a connection error to postgres database every minute.
I took the chance to update from 8.0.3 to 8.0.7 and rebooted. I still get the error meassages, but mails arriving again.
I am not sure if my issue issue is related to PMG or to Proxmox VE. I am running PMG on pve 8.1.3 in LXC container, installed with pve provided template "proxmox-mailgateway-8.0-standard_8.0-1_amd64.tar.zst".
Today I noticed that my PMG is not receiving mail any more. The log is showing showing a connection error to postgres database every minute.
Code:
Dec 12 17:29:31 pmg pmg-smtp-filter[336]: starting database maintenance
Dec 12 17:29:31 pmg pmg-smtp-filter[336]: end database maintenance (4 ms)
Dec 12 17:29:54 pmg systemd[1]: pg_receivewal@15-main.service: Scheduled restart job, restart counter is at 7.
Dec 12 17:29:54 pmg systemd[1]: Stopped pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.
Dec 12 17:29:54 pmg systemd[1]: Starting pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main...
Dec 12 17:29:54 pmg systemd[1]: Started pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.
Dec 12 17:29:54 pmg pg_backupcluster[893]: 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
Dec 12 17:29:54 pmg pg_backupcluster[891]: Error: pg_receivewal --cluster=15/main --slot pg_receivewal_service --create-slot --if-not-exists failed with exit code 256
Dec 12 17:29:54 pmg systemd[1]: pg_receivewal@15-main.service: Main process exited, code=exited, status=1/FAILURE
Dec 12 17:29:54 pmg systemd[1]: pg_receivewal@15-main.service: Failed with result 'exit-code'.
Dec 12 17:30:01 pmg CRON[896]: pam_unix(cron:session): session opened for user root(uid=0) by (uid=0)
Dec 12 17:30:01 pmg CRON[897]: (root) CMD (cd / && run-parts --report /etc/cron.hourly)
Dec 12 17:30:01 pmg CRON[896]: pam_unix(cron:session): session closed for user root
Dec 12 17:30:54 pmg systemd[1]: pg_receivewal@15-main.service: Scheduled restart job, restart counter is at 8.
Dec 12 17:30:54 pmg systemd[1]: Stopped pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.
Dec 12 17:30:54 pmg systemd[1]: Starting pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main...
Dec 12 17:30:54 pmg systemd[1]: Started pg_receivewal@15-main.service - WAL archival of PostgreSQL Cluster 15-main.
Dec 12 17:30:54 pmg pg_backupcluster[992]: 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
Dec 12 17:30:54 pmg pg_backupcluster[990]: Error: pg_receivewal --cluster=15/main --slot pg_receivewal_service --create-slot --if-not-exists failed with exit code 256
Dec 12 17:30:54 pmg systemd[1]: pg_receivewal@15-main.service: Main process exited, code=exited, status=1/FAILURE
Dec 12 17:30:54 pmg systemd[1]: pg_receivewal@15-main.service: Failed with result 'exit-code'.I took the chance to update from 8.0.3 to 8.0.7 and rebooted. I still get the error meassages, but mails arriving again.
I am not sure if my issue issue is related to PMG or to Proxmox VE. I am running PMG on pve 8.1.3 in LXC container, installed with pve provided template "proxmox-mailgateway-8.0-standard_8.0-1_amd64.tar.zst".
