When you install PostgreSQL as part of the IntelligenceCenter and/or DataCollector installation, a local Windows user named postgres is created. By default, the installer tries to create the password so that it never expires. However, if you have a Windows security policy that prevents the creation of users with passwords that don’t expire, the installer will not be able to create the user account with the proper setting and the password will expire after the number of days indicated by the Windows 2003 Maximum Password Age parameter (42 days by default). If the password associated with this user account expires, the PostgreSQL Database Server 8.2 service will not be able to start, which in turn will cause the IntelligenceCenter and/or DataCollector services on the machine to fail to start. To fix this, you must set a new password for the postgres user and configure the PostgreSQL Database Server 8.2 service to use the new password.
To reset the local postgres user password if it has already expired, do the following: