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.
If you do not already have the software, downloadPostgreSQLand install it.
Execute
psql
as the default database administrator user which ispostgres
. You'll have a PostgreSQL prompt afterwards.Create the database:
CREATE DATABASE rapidminer_server;
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.
If you do not already have the software, downloadPostgreSQLandpgAdminand install them.
RunpgAdmin.
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 ispostgres
with an empty password. In the connection tab be sure to have the host set tolocalhost
. ClickSaveafterwards.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
, selectCreate Login/Group Role
. Userm_user
as 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 Right-click on the item
Databases
, selectCreate -> Database
. Userapidminer_server
in theDatabaseinput field. Setownerto the new user created in the step above and clickSaveafterwards.
You now have finished preparing the RapidMiner Server database. To use the database you have to uselocalhost
as host,rm_user
as user,rm_password
as password andrapidminer_server
as schema in the RapidMiner Server installer. Return tothe installation instructionsto complete the RapidMiner Server installation.