Categories

Versions

You are viewing the RapidMiner Legacy documentation for version 9.9 - 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 a GUI, such as pgAdmin, or using the CLI.

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, download PostgreSQL and install it.

  2. Execute psql as the default database administrator user which is postgres. 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 to the installation instructions to complete the RapidMiner Server installation.

Using a GUI

Use these instructions to create a database using pgAdmin.

  1. If you do not already have the software, download PostgreSQL and pgAdmin and install them.

  2. Run pgAdmin.

  3. Right-click on the item Servers, select Create -> Server and provide the connection to your PostgreSQL instance set up in step 1. In the default PostgreSQL setup, the administrator user is postgres with an empty password. In the connection tab be sure to have the host set to localhost. Click Save afterwards.

    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 on Login/Group Roles, select Create Login/Group Role. Use rm_user as name. In the definition tab type in the user's password. In the privileges tab ensure that Can login? is set to Yes.

    pgAdmin Overview Create User Dialog
    pgAdmin Overview pgAdmin Create User
  5. Right-click on the item Databases, select Create -> Database. Use rapidminer_server in the Database input field. Set owner to the new user created in the step above and click Save afterwards.

    pgAdmin Create Database

You now have finished preparing the RapidMiner Server database. To use the database you have to use localhost as host, rm_user as user, rm_password as password and rapidminer_server as schema in the RapidMiner Server installer. Return to the installation instructions to complete the RapidMiner Server installation.