Categories

Versions

You are viewing the RapidMiner Server documentation for version 9.7 -Check here for latest version

Example: Creating a PostgreSQL Database Schema

The following instructions provide a sample that illustrates how to create a simple, open-source database server on your local machine (localhost) for use by the RapidMiner Server.

The example uses the following credentials:

Field Example Value
User rm_user
Password rm_password
Database schema name rapidminer_server

Follow the instructions to create a database using aGUI, such aspgAdmin, or using theCLI.

Using the command line

If you do not have a GUI available, for example when installing RapidMiner Server on a headless GNU/Linux machine, use the following instructions.

  1. If you do not already have the software, downloadPostgreSQLand install it.

  2. Executepsqlas the default database administrator user which ispostgres. You'll have a PostgreSQL prompt afterwards.

  3. Create the database:

    CREATE DATABASE rapidminer_server;
  4. Add a dedicated user for the database:

    CREATE USER rm_user WITH ENCRYPTED PASSWORD 'rm_password'; GRANT ALL PRIVILEGES ON DATABASE rapidminer_server TO rm_user;

You now have finished preparing the RapidMiner Server database. Return tothe installation instructionsto complete the RapidMiner Server installation.

Using a GUI

Use these instructions to create a database usingpgAdmin.

  1. If you do not already have the software, downloadPostgreSQLandpgAdminand install them.

  2. RunpgAdmin.

  3. Right-click on the item服务器s, select创建- >服务器and provide the connection to your PostgreSQL instance set up in step 1. In the default PostgreSQL setup, the administrator user ispostgreswith an empty password. In the connection tab be sure to have the host set tolocalhost. ClickSaveafterwards.

    pgAdmin Create Connection

  4. Separate applications should run with a separate database user. First, connect to the database by double-clicking on the instance name you created above. To create a new user, right-click onLogin/Group Roles, selectCreate Login/Group Role. Userm_useras name. In the definition tab type in the user's password. In the privileges tab ensure thatCan login?is set toYes.

    pgAdmin Overview Create User Dialog
    pgAdmin Overview pgAdmin Create User
  5. Right-click on the itemDatabases, selectCreate -> Database. Userapidminer_serverin theDatabaseinput field. Setownerto the new user created in the step above and clickSaveafterwards.

    pgAdmin Create Database

You now have finished preparing the RapidMiner Server database. To use the database you have to uselocalhostas host,rm_useras user,rm_passwordas password andrapidminer_serveras schema in the RapidMiner Server installer. Return tothe installation instructionsto complete the RapidMiner Server installation.