How do I prevent the postgres password from expiring?
search cancel

How do I prevent the postgres password from expiring?


Article ID: 166126


Updated On:




When you install PostgreSQL as part of the IntelligenceCenter or DataCollector installation, a postgres user name and password 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 postgres password expires, the PostgreSQL Database Server 8.2 service will fail to start, which in turn will prevent the IntelligenceCenter and DataCollector services from starting.


To prevent the PostgreSQL password from expiring, make sure that the postgres user account on the server(s) where IntelligenceCenter and/or DataCollector are installed is configured as follows:

  1. Click Start and then select Control Panel > Administrative Tools > Computer Management. The Computer Management dialog box appears.
  2. Expand Local Users and Groups in the left pane.
  3. Double-click the Users folder. The Windows users are displayed in the right pane.
  4. Double-click the postgres user in the right pane.
  5. On the General tab, select the Password never expires checkbox and then click OK.