Dear Proxmox Community,
I need help with my configuration, I do clustering and it was successful, but the state of the cluster was stuck at syncing only. the log says error:
2024-07-15T14:51:40.443368+07:00 pmg1 pmgmirror[776]: starting cluster synchronization
2024-07-15T14:51:40.466133+07:00 pmg1 pmgmirror[776]: database sync 'pmg2' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: connection to server on socket "/run/pmgtunnel/.s.PGSQL.2" failed: No such file or directory#012#011Is the server running locally and accepting connections on that socket? at /usr/share/perl5/PMG/DBTools.pm line 66.
2024-07-15T14:51:40.467020+07:00 pmg1 pmgmirror[776]: cluster synchronization finished (1 errors, 0.03 seconds (files 0.00, database 0.02, config 0.00))
While i run pg_lslusters:
root@pmg1:~# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
15 main 5432 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
My PMG hardware configuration:
2 vCPU
2gb Ram
30gb Storage
What's wrong? Thank you!
I need help with my configuration, I do clustering and it was successful, but the state of the cluster was stuck at syncing only. the log says error:
2024-07-15T14:51:40.443368+07:00 pmg1 pmgmirror[776]: starting cluster synchronization
2024-07-15T14:51:40.466133+07:00 pmg1 pmgmirror[776]: database sync 'pmg2' failed - DBI connect('dbname=Proxmox_ruledb;host=/run/pmgtunnel;port=2;','root',...) failed: connection to server on socket "/run/pmgtunnel/.s.PGSQL.2" failed: No such file or directory#012#011Is the server running locally and accepting connections on that socket? at /usr/share/perl5/PMG/DBTools.pm line 66.
2024-07-15T14:51:40.467020+07:00 pmg1 pmgmirror[776]: cluster synchronization finished (1 errors, 0.03 seconds (files 0.00, database 0.02, config 0.00))
While i run pg_lslusters:
root@pmg1:~# pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
15 main 5432 online postgres /var/lib/postgresql/15/main /var/log/postgresql/postgresql-15-main.log
My PMG hardware configuration:
2 vCPU
2gb Ram
30gb Storage
What's wrong? Thank you!