Product: All

Version & Build: 4.2.420 & up

The article will explain the reasons for PostgreSQL installation problems and the steps to resolve them.  Modus only supports PostgreSQL v8.06.

Important:

Before beginning a PostgreSQL installation, be aware that the program cannot be installed remotely.  The installation files must be accessed and executed on the server on which the program will be installed.

You may encounter the following errors during installation:

Initializing Database cluster... Failed to create process for INITDB logon \ failure, unknown username or bad password.

Failed to set permissions on installed files, please see log file in...

• You may have removed the Everyone / Full Control permissions on the drive where you have installed PostgreSQL
• There might be domain password policies set with specific restrictions (such as a required number of characters)
  • If the PostgreSQL password does not adhere to these rules, the install will fail
• You may have a Cisco Security Agent configured that prevents the installation of PostgreSQL

• Check the drive permissions
  • Add the PostgreSQL user to the installation location (default is C:\Program File\PostgreSQL) and give it Modify rights
  • If the installation resulted in the INITDB or permissions errors, the PostgreSQL folder should have been created
• If you have a Cisco Security Agent configured on your system, you must disable it before proceeding with the following:
  • In the Registry Editor, go to HKEY_LOCAL_MACHINE\Software\Vircom\Vopmail
  • Delete the MonitoringDSN key and its value  PGDB:dbname=Modus user=postgres password=****
  • From a Command Prompt, remove the PostgreSQL folder using the following commands:

net user postgresusername /delete

net user postgres ********** /add /fullname:"PostgreSQL Service" /comment:"" /expires:never /passwordchg:no

ntrights +r SeServiceLogonRight -u postgres

• Launch the Modus installer and select Mail Component only
  • Select Yes when prompted to proceed with the PostgreSQL installation