Connecting to a Remote PostgreSQL Database

Configure SystemLink to access a remote PostgreSQL database to enhance scalability and fault tolerance in Test Monitor.

Before you begin, contact your database administrator to determine the port and login credentials you need to connect to a PostgreSQL database. Refer to PostgreSQL documentation for more information on installing and setting up a PostgreSQL database.
  1. Launch NI SystemLink Server Configuration.
  2. Under NI SystemLink Service Manager, click PostgreSQLDatabase.
  3. Under Configuration, choose whether you want to connect using parameters or a connection string.
  4. If you want to connect using parameters, click Connect to an externally managed server using parameters and specify the following information:
    • Host—The name of the PostgreSQL server.
    • Port—The port this connection will use. The most common port is 5433.
    • Database—The name of the PostgreSQL database.
    • The username and password you use to connect to the PostgreSQL database.
  5. If you want to connect using a connection string, click Connect to an externally managed server using a connection string and enter it in the Npgsql connection string textbox.
    Refer to the Npgsql documentation for more information about connection string parameters.
  6. Click Apply.