RM Server putting all tables in the Postgres public schema

rachel_lomaskyrachel_lomasky MemberPosts:52Guru
edited December 2018 inHelp

I got RM talking to Postgres, but instead of putting its tables in the schema I indicated, they are all in the public schema. Is there a way around this?


http://java.sun.com/dtd/properties.dtd">

data/jdbc/postgresql-9.3-1101-jdbc4.jar
true
org.postgresql.Driver
mypass
5432
rapidminer
PostgreSQL
mymachine.cy5mwbb5zo5d.us-east-1.rds.amazonaws.com
myuser
null
true
8080

/opt/rapidminer
mykey
127.0.0.1
false
25
SUSE

2048
1081

RapidMiner_Server_7_5_1

RMS751SVC
false
<输入键= " radoop_proxy_enable " > false

Tagged:

Best Answer

  • rachel_lomaskyrachel_lomasky MemberPosts:52Guru
    Solution Accepted

    The db_url is:

    my_database.1.2.3.4/my_schema, where 1.2.3.4 is the IP of my database machine.

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    @BalazsBaranyany pointers for@rachel_lomasky?

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified ExpertPosts:949Unicorn

    Just to clarify:

    Some other databases have a different meaning of schema than PostgreSQL.

    In PostgreSQL, there's a "database" that can contain schemas. The default schema is "public". You can create schemas with "CREATE SCHEMA myschema" and deselect the "use default schema" checkbox in RapidMiner to refer your schema.

    This works well, I use RapidMiner heavily with PostgreSQL.

  • rachel_lomaskyrachel_lomasky MemberPosts:52Guru

    That's for the RM configuration tables, not the data that I am working with?

Sign InorRegisterto comment.