Custom PostgreSQL install on Windows

Introduction

When you install a private agent on Windows, PostgreSQL is installed to a default location; you cannot choose where to install it to. To specify a non-default location for a private agent's PostgreSQL instance, you must interrupt the normal installation process, then find and manually run part of the installation sequence. This page shows how to do that.

Install PostgreSQL to a specified location on Windows

To choose where to install PostgreSQL when installing a Windows private agent, follow these steps:

1. Perform a partial installation of the Jitterbit private agent:

   1. Run the private agent Windows standard installer.

   2. When you see the Install mode screen, stop. Do not click the Next or Cancel buttons:

      

      Important

      You will return to this window in later steps.

2. Find the install files:

   1. Open a file explorer, enter C:\%tmp% in the address bar, then press Enter:

      

   2. In the file explorer's search bar, enter postgresql*windows:

      

   3. On the found file, right-click and select Open file location. This is the temporary folder containing the expanded private agent installation package:

      

3. Install Microsoft Visual C++:

   1. Double-click the file vc14_23_redist_x64, then follow the wizard instructions to install Microsoft Visual C++.

4. Install PostgreSQL:

   1. Double-click the postgresql-14.5-1-windows-x64 file to start the installer, then follow the wizard instructions:

      1. On the Select components screen, deselect Stack Builder.

      2. On the Installation Directory screen, specify where you want to install PostgreSQL.

      3. On the Password screen, enter a password for the PostgreSQL server.

         Important

         Keep track of the password. It is required later.

      4. On the Port screen, specify a port number, or leave the default value.

      5. On the Advanced Options screen, leave the default value.

      6. Allow the installer to continue. On the last screen, Completing the PostgreSQL Setup Wizard, click the Finish button.

5. Complete the installation of the Jitterbit private agent:

   1. On the Install Mode screen of the Jitterbit Integration Platform installer window, select Advanced mode, then click the Next button.

   2. On the Destination Folder screen, specify where to install the private agent, or leave the default value, then click the Next button.

   3. On the Database administrative credentials screen, enter the PostgreSQL administrator password, then click the Next button.

   4. On the Resuming screen, click the Next button.

   5. On the Completed screen, click the Finish button.