Schema 'root' doesn't exist in ShardingSphere-Proxy 5.0

[wyxabd]

use PostgreSQL
For example:：select * from “root”.pagemanage
ERROR: Schema 'root' doesn't exist.

[RaigorJiang]

Hi @wyxabd
ShardingSphere manages distributed databases and coordinates data through logical schemas. If you do not create a root schema in ShardingSphere, it does not exist.

[wyxabd]

root schema is existed,but show ERROR

[RaigorJiang]

Please provide your schema configuration.

[wyxabd]

schemaName: jdt

dataSources:
primary_ds:
url: jdbc:postgresql://10.25.108.163:5432/jdt
username: postgres
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
replica_ds_0:
url: jdbc:postgresql://10.25.108.161:5432/jdt
username: postgres
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1

replica_ds_1:

url: jdbc:postgresql://127.0.0.1:5432/demo_replica_ds_1

username: postgres

password: postgres

connectionTimeoutMilliseconds: 30000

idleTimeoutMilliseconds: 60000

maxLifetimeMilliseconds: 1800000

maxPoolSize: 50

minPoolSize: 1

rules:

• !READWRITE_SPLITTING
  dataSources:
  pr_ds:
  writeDataSourceName: primary_ds
  readDataSourceNames:
  - replica_ds_0

- replica_ds_1

[RaigorJiang]

schemaName: jdt

dataSources: primary_ds: url: jdbc:postgresql://10.25.108.163:5432/jdt username: postgres password: 123456

Hi @wyxabd
From your configuration, the logic schema name is jdt, not root.
In ShardingSphere, users can not use pg schema in SQL, it shoud be logic schema.

[wyxabd]

use PostgreSQL
jdt is DatabaseName
root is SchemaName

[RaigorJiang]

@wyxabd
I understand what you mean, in PostgreSQL, database and schema have different meanings, but in ShardingSphere, database and schema both refer to logical database (or logic schema), which is somewhat different from using Postgres directly.

[RaigorJiang]

There is a related issue: #14004

[ZengYu1]

@RaigorJiang Hi, So how to access the schema of "root"

[RaigorJiang]

@ZengYu1 Can't do it now, can only use public schema

[github-actions]

Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.

[TeslaCN]

Schema supporting is improved in later version.