...
After installing or upgrading to the vCenter Server Appliance 6.0 using an embedded VMware Postgres database, you experience these symptoms: Under the vCenter Server Alarms, you receive one of these warning messages: VMware vFabric Postgres (vCenter_Server_Hostname) vmware-vpostgres status changes from green to yellow Under the Health Messages for the VMware Postgres service (located at Administration > System Configuration > Services), you see a message similar to: VMware Postgres memory usage has exceeded allocated quota. Used: xxxxx MB. Quota: xxx MB In the /etc/vmware-sca/health/vmware-postgres-health-status.xml file, you see entries similar to: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><healthStatus schemaVersion="1.0" xmlns="http://www.vmware.com/cis/cm/common/jaxb/healthstatus"><status>YELLOW</status><message messageKey="cis.vpg.health.mem_quota_exceeded" defaultMessage="VMware Postgres service memory usage has exceeded allocated quota."><param xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">1929<param xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">512</message><expiration>2015-03-19T06:02:10.000Z</expiration></healthStatus>
This is a known issue affecting the vCenter Server Appliance 6.0. This issue is resolved in vCenter Server Appliance 6.0 Update 1. For more information, see the vCenter Server 6.0 Update 1 Release Notes. Download the latest version at Customer Connect. To workaround this issue with the vCenter Server Appliance: Note: Performing these disables the VMware Postgres Monitoring agent. When you click on this, it shows the status:Failed to request health status from URI /etc/vmware-sca/health/vmware-postgres-health-status.xml Log in to the vCenter Server Appliance using SSH.Run this command to enable access the Bash shell: shell.set --enabled true Type shell and press Enter.Run this command to disable the periodic health checks: sed -ie 's/health_status_worker.naptime.*/health_status_worker.naptime = 2147483647/' /storage/db/vpostgres/health_status_worker.conf Run this command to reload the postgresql configuration:: service vmware-vpostgres reload Run this command to restart the health status worker process: pkill -f "postgres: bgworker: health_status_worker" Run this command to reset the alarm from Unknown to Green: sed -i -e 's#<status>.*</status>#<status>GREEN</status>#g' -e 's#<message.*message>#<message messageKey="cis.vpg.health.healthy" defaultMessage="VMware Postgres service is healthy."></message>#' -e "s#<expiration.*expiration>#<expiration>$(date +'%FT%T.000Z' -d '+2147483647 seconds')</expiration>#" /etc/vmware-sca/health/vmware-postgres-health-status.xml To work around this issue with a Windows installed vCenter Server: Connect to the vCenter Server machine.Open the C:\ProgramData\VMware\vCenterServer\data\vpostgres\health_status_worker.conf file with a plain text editor.Search for the line health_status_worker.naptime = 60 in the file.Change the value to 2147483647. For example: health_status_worker.naptime = 2147483647 Restart the vCenter Server and vPostgres services with these commands: C:\Program Files\VMware\vCenter Server\bin\> service-control --stop --allC:\Program Files\VMware\vCenter Server\bin\> service-control --start --all Note: For more information on restarting vCenter Server services, see Stopping, starting, or restarting VMware vCenter Server 6.0 services (2109881).
How to stop, start, or restart vCenter Server 6.x servicesvCenter Server Appliance 6.0 に警告が表示される: VMware Postgres サービスのメモリ使用量が割り当てられた量を超えましたO vCenter Server Appliance 6.0 exibe o aviso: uso da memória de serviço VMware Postgres excedeu a cota atribuídavCenter Server Appliance 6.0 muestra la advertencia: VMware Postgres service memory usage has exceeded allocated quotavCenter Server Appliance 6.0 显示警告: VMware Postgres 服务内存使用量已超过分配的配额