Installing EDB PgBouncer on a Windows host v1

Graphical installers for EDB PgBouncer are available via StackBuilder Plus (for EDB Postgres Advanced Server hosts) or Stack Builder (for PostgreSQL hosts).

The following steps walk you through installing EDB PgBouncer 1.16 by accessing StackBuilder Plus through Windows start menu

1. Access StackBuilder Plus through the Windows start menu; on the Welcome window, select your Advanced Server installation from the drop-down list. Click Next to continue to the application selection page.

Fig. 1: The StackBuilder Plus Welcome window

2. Expand the Add-ons, tools and utilities node, and check the box next to the PgBouncer v1.16.0.1-1. Click Next to continue.

Fig. 2: Expand Add-ons, Tools and Utilities

3. The selected packages and the default download directory where the package will be installed are displayed; change the download directory location if required. Click Next.

Fig. 3: Installation Directory

4. Once you have downloaded the installation files, a confirmation message is displayed. Click Next to start the EDB PgBouncer installation.

Fig. 4: Installing EDB PgBouncer

5. Select an installation language and click OK.

Fig. 5: The Language Selection window

6. The installer welcomes you to the setup wizard. Click Next.

Fig. 6: The EDB PgBouncer Welcome window

7. Use the Installation Directory field to specify the directory in which you wish to install EDB PgBouncer (the default installation directory is C:\Program Files\edb) Then, click Next to continue.
8. Use fields on the EDB Postgres Advanced Server Installation Details window to provide connection information for the Advanced Server host:

• Use the Host field to identify the system on which Advanced Server resides.
• Provide the name of the role that EDB PgBouncer will use for connections to the server in the User Name field.
• Provide the password associated with the role in the Password field.
• Use the Port field to identify the listener port that Advanced Server monitors for client connections.

Then, click Next to continue.

Fig. 7: The Advanced Server Installation Details window

9. Use fields on the PgBouncer Configurations window to provide your preferences for the PgBouncer installation:

• Use the Listening Port field to specify the port that PgBouncer monitors for connections.
• Use the Operating System User field to specify the name of the Linux operating system user that EDB PgBouncer will change to after startup. This option is not supported on Windows hosts.

Fig. 8: The EDB PgBouncer Configuration window

10. The Ready to Install window notifies you when the installer has all of the information needed to install EDB PgBouncer on your system. Click Next to install EDB PgBouncer. Progress bars inform you as the installation progresses.

Fig. 9: The Ready to Install window

11. The installer notifies you when the setup wizard has completed the installation. Click Finish to exit the installer.

Fig. 10: The installation is complete