Symptoms:
Agent can't send heartbeats because socket address structure initialization is failing
VMware vCenter Server 6.5.x
VMware vCenter Server 6.7.x
VMware vCenter Server 7.x
VMware vCenter Server 8.x
$ /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
$ select id,dns_name,management_ip from vpx_host where dns_name like '<vCenter_FQDN>'
1. Take a backup of the vCenter Server database. See Back up and restore vCenter Server Appliance/vCenter Server 6.x vPostgres database
2. Stop the vCenter vpxd service:
$ service-control --stop vmware-vpxd
3. Execute the following SQL query:
$ update vpx_host set management_ip = <vCenter_Server_IP_Address>
4. Start the vCenter Server service. $ service-control --start vmware-vpxd
5. Reconnect the ESXi host.