Media Server 25.1
Media Server Help

# Create a PostgreSQL DSN on Windows

This section describes how to create a PostgreSQL data source name (DSN), so that Media Server can connect to your database. You must complete these steps on every Media Server host.

TIP: Create the DSN on the same machine as Media Server. If your Media Server is running on Linux, see Create a PostgreSQL DSN on Linux.

To create a PostgreSQL DSN on Windows

1. Download and install the PostgreSQL ODBC driver.
2. Open the ODBC Data Sources program (Windows Control Panel > Administrative Tools > ODBC Data Sources 64-bit).

3. In the User DSN or System DSN tab, click Add... . (System DSNs are available to all users. If you create a User DSN, check which user the Media Server service is running as).

   The Create New Data Source dialog box opens.

4. In the list, select PostgreSQL Unicode(x64) and click Finish.

   The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box opens.

5. Type the following information:

   Data Source | A name for the new data source. You will configure Media Server to use this data source name.
   Description | An optional description for the data source.
   Database | The name of the database that you created.
   SSL Mode | Whether to use SSL to connect to the database server. NOTE: To enable SSL, you must also configure the database server to support SSL. For instructions, refer to the PostgreSQL documentation.
   Server | The IP address or hostname of the database server.
   Port | The database server port.
   User Name | The user name of the user you created for Media Server.
   Password | The password of the user you created for Media Server.

6. Click Datasource.

   The Advanced Options dialog box opens.

7. (Optional) OpenText recommends that you select the Use Declare/Fetch check box, to reduce memory use.
8. Click Page 2.

9. Select the bytea as LO check box.

   IMPORTANT: If you do not select this option, Media Server fails to start.

10. Click Apply and then OK.

11. Click Test to test the connection.

    A dialog box opens, describing the result of the test. If the connection failed, use the information in the message to resolve any issues.

12. Click OK to close the Connection Test box.
13. Click Save to close the PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box.

14. Click OK to close the ODBC Data Source Administrator dialog box.

    You can now configure Media Server to connect to the database (see Configure Media Server).

Copyright 2024 Open Text
Version 25.1 | Last updated January 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Media Server 25.1

Topic Title: Create a PostgreSQL DSN on Windows