5.1.1.1.1. PostgreSQL Installation¶

• PostgreSQL can be downloaded from the URL below.

  After you download the one appropriate to the environment, please proceed on the installation.
  http://www.enterprisedb.com/products-services-training/pgdownload （English）

  In case of PostgreSQL 9.3 (32bit), click <Win x86-32>.

  In case of PostgreSQL 9.3 (64bit), click <Win x86-64>.

5.1.1.1.2. Database and Log-in Role Creation¶

1. Start up pgAdmin tool.

2. Log-in rule creation

   Right click [Log-in Role] from [Object Browser] and click [New Log-in Role].

   Sub-window is displayed.

   

   Enter following items and click [OK].

   Property Tab
      [Role Name] (optional)
   
   Definition Tab
      [Password] (optional)
   

   Note

   Following contents are specified as an example in this document.

   Role name [imart]

   Password [imart]

3. Database Creation

Right click [Database] from [Object Browser] and click [New Database].

Sub-window is displayed.

Enter following items, select them, and click [OK].

Property Tab
   [Name](optional)
   [Owner](log-in role which was created in [2. Log-in Rule Creation] described above)

Note

Following contents are specified as an example in this document.

Name [iap_db]

Owner [imart]

Go to [ JDBC Driver ].