Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > Database Connections and PostgreSQL Max Connection in Web Help Desk

Database Connections and PostgreSQL Max Connection in Web Help Desk

Updated July 25, 2018

Overview

This article describes how to properly modify the DATABASE_CONNECTIONS in the Web Help Desk whd.conf file and MAX_CONNECTIONS in the postgresql.conf file.

Environment

  • Web Help Desk version 12.5.2
  • PostgreSQL
  • Windows Environment

Detail

When you modify the number of allowed database connections in your whd.conf file, you should always set the DATABASE_CONNECTIONS as 50% of your max_connections in your postgresql.conf file.

 

Please see the example below.

Database connections in whd.conf file

  1. Go to <WebHelpDesk>\conf (by default, C:\Program Files\WebHelpDesk\conf).
  2. Open whd.conf in a text editor such as Notepad.
  3. Search for Database Connections and set the number of allowed simultaneous database connections.
    # ------------------------------------------------------
    # Database Connections
    #
    # Number of allowed simultaneous database connections.
    # Large installations may benefit from increasing this limit. 
    
    DATABASE_CONNECTIONS=50
  4. Save the file.
  5. Restart the Web Help Desk service.

Database connections in postgresql.conf file

  1. Go to <WebHelpDesk>\pgsql9\data (by default, C:\Program Files\WebHelpDesk\pgsql9\data).
  2. Open postgresql.conf in a text editor such as Notepad.
  3. Search for CONNECTIONS AND AUTHENTICATION and set the value of max_connections.
    # (change requires restart)
    max_connections = 100    ​​​​​
  4. Save the file.
  5. Restart the Web Help Desk service.

 

 

Last modified

Tags

Classifications

Public