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
- Download and install the PostgreSQL ODBC driver.
- Open the ODBC Data Sources program (Windows Control Panel > Administrative Tools > ODBC Data Sources 64-bit).
-
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.
-
In the list, select PostgreSQL Unicode(x64) and click Finish.
The PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box opens.
-
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. -
Click Datasource.
The Advanced Options dialog box opens.
- (Optional) OpenText recommends that you select the Use Declare/Fetch check box, to reduce memory use.
- Click Page 2.
-
Select the bytea as LO check box.
IMPORTANT: If you do not select this option, Media Server fails to start.
-
Click Apply and then OK.
-
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.
- Click OK to close the Connection Test box.
- Click Save to close the PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box.
-
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).