Skip to main content

BriefCam Installation Guide

PostgreSQL Installation

Last Updated: 4 minute read
Version2024r2
LanguageEnglish

Prerequisites

  • When running the PostgreSQL installer, you are asked to select a data drive. For this drive, in the properties, uncheck the Allow files on this drive to have contents indexed in addition to file properties checkbox.

    allow files.png

  • The following ports are required during the BriefCam installation for PostgreSQL. Make sure that it is available before starting the installation:

    Component

    Port #

    DB

    TCP 5432 (or as provided)

    Redis

    TCP 6379

Note

BriefCam cannot interface with a customer-managed PostgreSQL instance even if such an instance exists.

Installation Steps

  1. To run the PostgreSQL Installation wizard, right-click on the BriefCamPostgreSQL_<Version number>.exe file and select Run as administrator.

    If you are using the latest Windows Update and a Windows Defender alert appears, click the More info link and click Run anyway.

    Windows protected your PC4.png

  2. The installation checks for prerequisites. If anything is missing, the following screen will appear. Click Next.

    PostresPrerequisites.png

  3. In this screen, the prerequisites checked are the missing prerequisites. Click Next to install them.

    Postresq_prereqs_2026_R1.png

  4. In the Welcome screen, click Get Started.

    PostgreSQLWelcome.png

  5. Accept the terms of the license agreement and click Next.

    PostgresLicense.png

    The following screen will appear.

    PostgresInstallPath.png

  6. Select the drive where you want to install PostgreSQL.

  7. Select the drive where you want to install the PostgreSQL data. The path to the PostgreSQL data cannot contain special characters, such as space, ~, and &.

  8. Select the drive where you want to install the PostgreSQL scripts. It is recommended that both paths be set to a local SSD drive.

  9. Click Next.

    The following screen will appear.

    PostgresUser.png

  10. Select whether to use an existing account or create a new account.

  11. By default, BriefCam will populate the Username field with bcuser. Leave it as is or change it.

  12. Enter the password. Note that special characters are not supported in the Password field.

    Use a password that is compliant with your password policy.

    It is important that you remember the password since you will be prompted to use this password in the following BriefCam component installations.

    A password may fail for a variety of reasons:

    • The password does not meet the password policy of the operating system and/or organization.

    • Domain accounts cannot be created by this dialog. Contact the relevant IT person if a new domain account is needed.

    • If the user is disabled, locked, or otherwise limited.

  13. If the user is a domain user, enter the domain name and make sure that the domain user has full admin privileges on the server. If the user is a local user, enter a period (.).

    Note

    The domain and user names are case sensitive.

  14. If you selected to use an existing user, click Validate Existing User to check that the user credentials are valid.

  15. For new users, you can select the Deny remote login for the BriefCam user checkbox to prevent the BriefCam user from remotely logging into the machine. If the checkbox is not checked, it will be possible to give the BriefCam user access to remote login (depending on your organization’s policies).

  16. Click Next.

    The following screen will appear.

    PostgresDBAccounts.png

  17. Define a PostgreSQL administrator user and password both for the root account (for system administration) and for the application user.

    Only English letters and whole numbers are supported for these fields. 

  18. Confirm the database listening port or select a new one if a non-default one is used. If you use a non-default one, you will also have to use the same non-default port in the other installers.

  19. Click Next.

    The following screen will appear.

    PostgresSharedFolder.png

  20. Select the data drive that will hold the BriefCam data, including longer blobs, database backups, rendered synopsis files, and more.

    • It's recommended to select the drive with sufficient available space based on the specifications provided by BriefCam.

    • The path to the PostgreSQL data cannot contain special characters, such as space, ~, and &.

    • If you select an existing shared network folder, make sure that the user has permissions to the shared network folder.

    • In the properties of the drive you select, make sure you unchecked the Allow files on this drive to have contents indexed in addition to file properties checkbox (as described in the prerequisites above).

    The set up will automatically create a shared BriefCam folder on the selected drive.

    If you want to select a mapped drive, make sure to first map the drive and then select it from the BriefCam Shared Data folder screen.

  21. Click Install.

  22. Your PostgreSQL installation is now complete. Click Finish.

Note

If you want to move the BriefCam network share to another location, see Moving the BriefCam Network Share.

Uninstalling the PostgreSQL Component

Note

If the PostgreSQL component is uninstalled, the PostgreSQL base directory and data directory, as specified during the installation, must be manually removed.