How To Start Postgresql Service In Windows

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

The procedure describes setting upwards the database server using the psql command-line tool. If yous prefer, you lot tin use the pgAdmin graphical user interface. For more data, refer to the pgAdmin documentation on www.pgadmin.org.

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

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

NOTE:

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

Add together the PostgreSQL bin directory path to the PATH environmental variable.

Notation:

This step enables you lot to apply the command psql to start the PostgreSQL command-line tool (psql) from the Windows Command Prompt. If the directory path is non added to the PATH variable, you must specify the psql.exe file path in the Command Prompt to start 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	Any proper noun.
Encoding	Must exist 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 inside the public schema.

Micro Focus recommends running the following command to ensure that the script stops running if it encounters an error:
```
\gear up 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 frontward slashes. The psql command-line tool does not recognize backslashes in file paths.

Grant privileges to the user that Media Server will connect equally. If security is not a consideration you could grant all privileges, but 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 y'all created.
`userName`	is the user proper noun that Media Server will connect as.

Open the Information Sources (ODBC) plan:

In the Windows Control Panel, click Organization and Security.

The System and Security window opens.
Click Administrative Tools.

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

The ODBC Data Source Administrator dialog box opens.

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

The Create New Data Source dialog box opens.

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

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

Complete the data source information fields:

Data Source	The data source name (DSN). Media Server uses this string to connect to the database server.
Database	The name of the database that you created in Step 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.
Clarification	An optional description for the data source.
SSL Manner	Whether to utilise SSL to connect to the database server. Note: To enable SSL style, you lot must also configure the database server to back up 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 account that connects to the database server.

Click Datasource.

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

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

Click Page 2.

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

Select the bytea as LO check box.

Click Apply and and so OK.

The Avant-garde Options (driverName) 2/two dialog box closes.

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

The Connection Test box opens containing a bulletin describing whether the connection was successful. If the connection failed, utilise the information in the message to resolve any issues.

Click OK to close the Connection Test box.

In the PostgreSQL Unicode ODBC Driver (psqlODBC) Setup dialog box, click Relieve to close the dialog box.

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

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

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: bryanreptaked1956.blogspot.com