How To Install Postgresql On Windows

To utilise Media Server with a PostgreSQL database, you must download and install a PostgreSQL server and ODBC driver, and configure Media Server to connect to the database through the driver.

The procedure describes setting upward the database server using the psql command-line tool. If y'all prefer, you can employ the pgAdmin graphical user interface. For more information, refer to the pgAdmin documentation on www.pgadmin.org.

Download and install a PostgreSQL server. For instructions, refer to the PostgreSQL documentation on world wide web.postgresql.org.

Ensure that the installation includes the PostgreSQL Unicode ODBC driver.
During installation, set up a user account with superuser privileges.

NOTE:

Once installed, the PostgreSQL server appears in the Services tab in Windows Task Director.

Add the PostgreSQL bin directory path to the PATH ecology variable.

Note:

This step enables you to utilise the control psql to outset the PostgreSQL control-line tool (psql) from the Windows Command Prompt. If the directory path is not added to the PATH variable, yous must specify the psql.exe file path in the Control Prompt to kickoff psql.

Open the psql command-line tool:

In the Windows Command Prompt, run the command:

psql -U                userName

Enter your countersign when prompted.

Run a CREATE DATABASE control to create a new database. Specify the post-obit database settings.

Database name	Whatsoever name.
Encoding	Must be Unicode–either UTF8 or UCS2.
Collation	Any that is compatible with the encoding.
Locale	Any that is compatible with the encoding.

For example:

CREATE DATABASE myDatabase WITH ENCODING 'UTF8' LC_COLLATE='English_United Kingdom' LC_CTYPE='English_United Kingdom';

Connect to the new database using the control:

\c            databaseName

Run the postgres.sql script provided in the Media Server installation directory. This script sets up the database schema that Media Server requires. The schema is inserted within the public schema.

Micro Focus recommends running the post-obit command to ensure that the script stops running if it encounters an mistake:
```
\fix ON_ERROR_STOP on
```
Run the script using the command:
```
\i                'path/postgres.sql'
```
where path is the script file path.

NOTE:

Replace backslashes in the file path with forward slashes. The psql control-line tool does not recognize backslashes in file paths.

Grant privileges to the user that Media Server will connect every bit. If security is non a consideration you could grant all privileges, only the required privileges are:

Database	Create Temporary Tables
All tables	Select, Insert, Update, Delete
All functions and stored procedures	Execute
All sequences	Usage

For example:

GRANT TEMP ON DATABASE            databaseName            TO            userName; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO            userName; GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO            userName; GRANT USAGE ON ALL SEQUENCES IN SCHEMA public TO            userName;

where,

`databaseName`	is the name of the database that yous created.
`userName`	is the user proper noun that Media Server volition connect equally.

Open the Data Sources (ODBC) program:

In the Windows Control Panel, click Organization and Security.

The System and Security window opens.
Click Administrative Tools.

The Administrative Tools window opens.
Double-click Information Sources (ODBC).

The ODBC Data Source Ambassador dialog box opens.

In the User DSN tab, click Add... .

The Create New Data Source dialog box opens.

Select the PostgreSQL Unicode driver from the listing and click Finish.

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

Complete the data source information fields:

Information Source	The information source name (DSN). Media Server uses this string to connect to the database server.
Database	The proper name of the database that y'all created in Pace 2.
Server	The IP address or hostname of the server that the database server is installed on.
User Name	The user name to connect to the database server with.
Description	An optional clarification for the data source.
SSL Mode	Whether to employ SSL to connect to the database server. NOTE: To enable SSL mode, you must as well configure the database server to support SSL. For instructions, refer to the PostgreSQL documentation.
Port	The port to use to communicate with the database server.
Password	The password for the user business relationship that connects to the database server.

Click Datasource.

The Avant-garde Options (driverName) 1/2 dialog box opens.

(Optional) Micro Focus recommends that you select the Apply Declare/Fetch bank check box, to reduce memory use.

Click Page 2.

The Advanced Options (driverName) 2/2 dialog box opens.

Select the bytea equally LO bank check box.

Click Apply and then OK.

The Advanced Options (driverName) 2/2 dialog box closes.

In the PostgreSQL Unicode ODBC Commuter (psqlODBC) Setup dialog box, click Test to test the connectedness.

The Connection Exam box opens containing a message describing whether the connection was successful. If the connection failed, use the data in the bulletin to resolve any issues.

Click OK to shut the Connection Exam box.

In the PostgreSQL Unicode ODBC Commuter (psqlODBC) Setup dialog box, click Save to shut the dialog box.

In the ODBC Information Source Administrator dialog box, click OK to close the dialog box.

Y'all can now configure Media Server to connect to the database (see Configure Media Server).

How To Install Postgresql On Windows,

Source: https://www.microfocus.com/documentation/idol/IDOL_12_0/MediaServer/Guides/html/English/Content/Getting_Started/Configure/_TRN_Set_up_PostgreSQL.htm

Posted by: musialanated1978.blogspot.com