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
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.
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 ODBC Data Source Administrator dialog box.
You can now configure Media Server to connect to the database (see Configure Media Server).