This is an automated email from the ASF dual-hosted git repository.
zhangliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new 250ada69b8b Dynamic config use command instead of using cnf,conf file
at IT (#19518)
250ada69b8b is described below
commit 250ada69b8bf5626d4ee482d3ebe52e869ac8b25
Author: Xinze Guo <[email protected]>
AuthorDate: Wed Jul 27 21:17:37 2022 +0800
Dynamic config use command instead of using cnf,conf file at IT (#19518)
* Use command instead of database cnf,conf file
* Remove unused file
* Remove useless command
* Use command only for dynamic config
* Change name
* Upgrade codestyle
* Add server-id, fix ci error
* Config add max_connections
* Improve PostgreSQLContainer use config correct file
---
.../atomic/storage/StorageContainerFactory.java | 9 ++--
.../atomic/storage/impl/MySQLContainer.java | 8 +++-
.../atomic/storage/impl/OpenGaussContainer.java | 14 +++++-
.../atomic/storage/impl/PostgreSQLContainer.java | 17 ++++++-
.../env/container/atomic/util/CommandPartUtil.java | 53 ++++++++++++++++++++++
.../env/runtime/DataSourceEnvironment.java | 3 +-
.../pipeline/env/IntegrationTestEnvironment.java | 12 ++++-
.../container/compose/DockerComposedContainer.java | 5 +-
.../src/test/resources/env/mysql/my.cnf | 3 ++
.../test/resources/env/postgresql/postgresql.conf | 1 +
.../src/test/resources/env/mysql/my.cnf | 3 ++
.../test/resources/env/postgresql/postgresql.conf | 1 +
12 files changed, 115 insertions(+), 14 deletions(-)
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
index 14ee92e68a9..1a949ccd6c7 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/StorageContainerFactory.java
@@ -38,16 +38,17 @@ public final class StorageContainerFactory {
* @param dockerImageName docker image name
* @param scenario scenario
* @param useRootUsername use root username
+ * @param commandParts command parts
* @return created instance
*/
- public static StorageContainer newInstance(final DatabaseType
databaseType, final String dockerImageName, final String scenario, final
boolean useRootUsername) {
+ public static StorageContainer newInstance(final DatabaseType
databaseType, final String dockerImageName, final String scenario, final
boolean useRootUsername, final String... commandParts) {
switch (databaseType.getType()) {
case "MySQL":
- return new MySQLContainer(dockerImageName, scenario,
useRootUsername);
+ return new MySQLContainer(dockerImageName, scenario,
useRootUsername, commandParts);
case "PostgreSQL":
- return new PostgreSQLContainer(dockerImageName, scenario,
useRootUsername);
+ return new PostgreSQLContainer(dockerImageName, scenario,
useRootUsername, commandParts);
case "openGauss":
- return new OpenGaussContainer(dockerImageName, scenario,
useRootUsername);
+ return new OpenGaussContainer(dockerImageName, scenario,
useRootUsername, commandParts);
case "H2":
return new H2Container(scenario);
default:
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
index 66386399b33..ec52ecaab1d 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/MySQLContainer.java
@@ -29,13 +29,17 @@ import java.util.Optional;
*/
public final class MySQLContainer extends DockerStorageContainer {
- public MySQLContainer(final String dockerImageName, final String scenario,
final boolean useRootUsername) {
+ private final String[] commandParts;
+
+ public MySQLContainer(final String dockerImageName, final String scenario,
final boolean useRootUsername, final String... commandParts) {
super(DatabaseTypeFactory.getInstance("MySQL"),
Strings.isNullOrEmpty(dockerImageName) ? "mysql/mysql-server:5.7" :
dockerImageName, scenario, useRootUsername);
+ this.commandParts = commandParts;
}
@Override
protected void configure() {
- withCommand("--sql_mode=",
"--default-authentication-plugin=mysql_native_password",
"--lower_case_table_names=1");
+ // command config will override config at my.cnf.
+ setCommand(commandParts);
addEnv("LANG", "C.UTF-8");
addEnv("MYSQL_ROOT_PASSWORD", getUnifiedPassword());
addEnv("MYSQL_ROOT_HOST", "%");
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
index 86631671296..a9edd1b01b7 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/OpenGaussContainer.java
@@ -22,6 +22,8 @@ import
org.apache.shardingsphere.infra.database.type.DatabaseTypeFactory;
import
org.apache.shardingsphere.test.integration.env.container.atomic.storage.DockerStorageContainer;
import org.testcontainers.containers.BindMode;
+import java.util.LinkedList;
+import java.util.List;
import java.util.Optional;
/**
@@ -29,13 +31,21 @@ import java.util.Optional;
*/
public final class OpenGaussContainer extends DockerStorageContainer {
- public OpenGaussContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername) {
+ private final String[] commandParts;
+
+ public OpenGaussContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername, final String... commandParts) {
super(DatabaseTypeFactory.getInstance("openGauss"),
Strings.isNullOrEmpty(dockerImageName) ? "enmotech/opengauss:3.0.0" :
dockerImageName, scenario, useRootUsername);
+ this.commandParts = commandParts;
}
@Override
protected void configure() {
- withCommand("--max_connections=600");
+ List<String> commandParts = new LinkedList<>();
+ for (String each : this.commandParts) {
+ commandParts.add("-c");
+ commandParts.add(each);
+ }
+ setCommand(commandParts.toArray(new String[0]));
addEnv("GS_PASSWORD", getUnifiedPassword());
withClasspathResourceMapping("/env/postgresql/postgresql.conf",
"/usr/local/opengauss/share/postgresql/postgresql.conf.sample",
BindMode.READ_ONLY);
withClasspathResourceMapping("/env/opengauss/pg_hba.conf",
"/usr/local/opengauss/share/postgresql/pg_hba.conf.sample", BindMode.READ_ONLY);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
index d7bb1e0882c..25551d22d33 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/storage/impl/PostgreSQLContainer.java
@@ -20,8 +20,11 @@ package
org.apache.shardingsphere.test.integration.env.container.atomic.storage.
import com.google.common.base.Strings;
import org.apache.shardingsphere.infra.database.type.DatabaseTypeFactory;
import
org.apache.shardingsphere.test.integration.env.container.atomic.storage.DockerStorageContainer;
+import
org.apache.shardingsphere.test.integration.env.container.atomic.util.CommandPartUtil;
import org.testcontainers.containers.BindMode;
+import java.util.LinkedList;
+import java.util.List;
import java.util.Optional;
/**
@@ -29,13 +32,23 @@ import java.util.Optional;
*/
public final class PostgreSQLContainer extends DockerStorageContainer {
- public PostgreSQLContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername) {
+ private static final String[] DEFAULT_COMMAND_PARTS = new
String[]{"config_file=/etc/postgresql/postgresql.conf"};
+
+ private final String[] commandParts;
+
+ public PostgreSQLContainer(final String dockerImageName, final String
scenario, final boolean useRootUsername, final String... commandParts) {
super(DatabaseTypeFactory.getInstance("PostgreSQL"),
Strings.isNullOrEmpty(dockerImageName) ? "postgres:12-alpine" :
dockerImageName, scenario, useRootUsername);
+ this.commandParts = commandParts;
}
@Override
protected void configure() {
- withCommand("--max_connections=600", "--wal_level=logical");
+ List<String> commandParts = new LinkedList<>();
+ for (String each :
CommandPartUtil.mergeCommandParts(DEFAULT_COMMAND_PARTS, this.commandParts)) {
+ commandParts.add("-c");
+ commandParts.add(each);
+ }
+ setCommand(commandParts.toArray(new String[0]));
addEnv("POSTGRES_USER", getRootUsername());
addEnv("POSTGRES_PASSWORD", getUnifiedPassword());
withClasspathResourceMapping("/env/postgresql/postgresql.conf",
"/etc/postgresql/postgresql.conf", BindMode.READ_ONLY);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
new file mode 100644
index 00000000000..665513b29d1
--- /dev/null
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/container/atomic/util/CommandPartUtil.java
@@ -0,0 +1,53 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.shardingsphere.test.integration.env.container.atomic.util;
+
+import java.util.LinkedHashMap;
+import java.util.Map;
+
+/**
+ * Command part util.
+ */
+public final class CommandPartUtil {
+
+ /**
+ * Merge command parts.
+ *
+ * @param defaultCommandParts default command parts
+ * @param inputCommandParts input command parts, will override default
command parts
+ * @return merged command parts
+ */
+ public static String[] mergeCommandParts(final String[]
defaultCommandParts, final String[] inputCommandParts) {
+ if (null == defaultCommandParts || defaultCommandParts.length == 0) {
+ return inputCommandParts;
+ }
+ if (null == inputCommandParts || inputCommandParts.length == 0) {
+ return defaultCommandParts;
+ }
+ Map<String, String> defaultPartsMap = new LinkedHashMap<>();
+ for (String each : defaultCommandParts) {
+ String[] split = each.split("=");
+ defaultPartsMap.put(split[0], split[1]);
+ }
+ for (String each : inputCommandParts) {
+ String[] split = each.split("=");
+ defaultPartsMap.put(split[0], split[1]);
+ }
+ return defaultPartsMap.entrySet().stream().map(entry -> entry.getKey()
+ "=" + entry.getValue()).toArray(String[]::new);
+ }
+}
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
index 19ad268f94c..7b45da302fb 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-env/src/test/java/org/apache/shardingsphere/test/integration/env/runtime/DataSourceEnvironment.java
@@ -90,7 +90,8 @@ public final class DataSourceEnvironment {
case "H2":
return
String.format("jdbc:h2:mem:%s;DB_CLOSE_DELAY=-1;DATABASE_TO_UPPER=false;MODE=MySQL;USER=root;PASSWORD=Root@123",
dataSourceName);
case "MySQL":
- return
String.format("jdbc:mysql://%s:%s/%s?useServerPrepStmts=true&serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8",
host, port, dataSourceName);
+ return
String.format("jdbc:mysql://%s:%s/%s?useServerPrepStmts=true&serverTimezone=UTC&useSSL=false&useLocalSessionState=true&characterEncoding=utf-8&allowPublicKeyRetrieval=true",
+ host, port, dataSourceName);
case "PostgreSQL":
return String.format("jdbc:postgresql://%s:%s/%s", host, port,
dataSourceName);
case "SQLServer":
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
index f76bd59606b..6640b8fcc23 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/env/IntegrationTestEnvironment.java
@@ -18,6 +18,7 @@
package org.apache.shardingsphere.integration.data.pipeline.env;
import lombok.Getter;
+import lombok.SneakyThrows;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.apache.shardingsphere.infra.database.type.DatabaseType;
@@ -47,20 +48,27 @@ public final class IntegrationTestEnvironment {
private final List<String> openGaussVersions;
+ private final String[] commandParts;
+
private IntegrationTestEnvironment() {
props = loadProperties();
itEnvType =
ScalingITEnvTypeEnum.valueOf(StringUtils.defaultIfBlank(props.getProperty("scaling.it.env.type").toUpperCase(),
ScalingITEnvTypeEnum.NONE.name()));
mysqlVersions =
Arrays.stream(props.getOrDefault("scaling.it.docker.mysql.version",
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
postgresVersions =
Arrays.stream(props.getOrDefault("scaling.it.docker.postgresql.version",
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
openGaussVersions =
Arrays.stream(props.getOrDefault("scaling.it.docker.opengauss.version",
"").toString().split(",")).filter(StringUtils::isNotBlank).collect(Collectors.toList());
+ String commands = props.getOrDefault("scaling.it.database.command",
"").toString();
+ if (StringUtils.isNotBlank(commands)) {
+ commandParts = commands.split(",");
+ } else {
+ commandParts = new String[0];
+ }
}
+ @SneakyThrows(IOException.class)
private Properties loadProperties() {
Properties result = new Properties();
try (InputStream inputStream =
IntegrationTestEnvironment.class.getClassLoader().getResourceAsStream("env/it-env.properties"))
{
result.load(inputStream);
- } catch (final IOException ex) {
- throw new RuntimeException(ex);
}
for (String each : System.getProperties().stringPropertyNames()) {
result.setProperty(each, System.getProperty(each));
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
index 0618151fe0d..a5d8b518453 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/java/org/apache/shardingsphere/integration/data/pipeline/framework/container/compose/DockerComposedContainer.java
@@ -19,6 +19,7 @@ package
org.apache.shardingsphere.integration.data.pipeline.framework.container.
import lombok.Getter;
import org.apache.shardingsphere.infra.database.type.DatabaseType;
+import
org.apache.shardingsphere.integration.data.pipeline.env.IntegrationTestEnvironment;
import
org.apache.shardingsphere.integration.data.pipeline.framework.container.proxy.ShardingSphereProxyDockerContainer;
import
org.apache.shardingsphere.test.integration.env.container.atomic.governance.GovernanceContainer;
import
org.apache.shardingsphere.test.integration.env.container.atomic.governance.impl.ZookeeperContainer;
@@ -31,6 +32,8 @@ import
org.apache.shardingsphere.test.integration.env.runtime.DataSourceEnvironm
*/
public final class DockerComposedContainer extends BaseComposedContainer {
+ private static final IntegrationTestEnvironment ENV =
IntegrationTestEnvironment.getInstance();
+
private final DatabaseType databaseType;
private final ShardingSphereProxyDockerContainer proxyContainer;
@@ -41,7 +44,7 @@ public final class DockerComposedContainer extends
BaseComposedContainer {
public DockerComposedContainer(final DatabaseType databaseType, final
String dockerImageName) {
this.databaseType = databaseType;
GovernanceContainer governanceContainer =
getContainers().registerContainer(new ZookeeperContainer());
- storageContainer =
getContainers().registerContainer((DockerStorageContainer)
StorageContainerFactory.newInstance(databaseType, dockerImageName, "", false));
+ storageContainer =
getContainers().registerContainer((DockerStorageContainer)
StorageContainerFactory.newInstance(databaseType, dockerImageName, "", false,
ENV.getCommandParts()));
ShardingSphereProxyDockerContainer proxyContainer = new
ShardingSphereProxyDockerContainer(databaseType);
proxyContainer.dependsOn(governanceContainer, storageContainer);
ShardingSphereProxyDockerContainer anotherProxyContainer = new
ShardingSphereProxyDockerContainer(databaseType);
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
index 1a0e57d805e..552b13ae282 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/mysql/my.cnf
@@ -23,5 +23,8 @@ log-bin=mysql-bin
binlog-format=row
binlog-row-image=full
max_connections=600
+default-authentication-plugin=mysql_native_password
+sql_mode=
+lower_case_table_names=1
# for mysql 8.0
secure_file_priv=/var/lib/mysql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
index 15a4d3136dd..9d432a4cab4 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-scaling/src/test/resources/env/postgresql/postgresql.conf
@@ -17,6 +17,7 @@
listen_addresses = '*'
wal_level = logical
+max_connections = 600
max_replication_slots = 10
log_timezone = 'Asia/Shanghai'
datestyle = 'iso, mdy'
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
index 1a0e57d805e..552b13ae282 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/mysql/my.cnf
@@ -23,5 +23,8 @@ log-bin=mysql-bin
binlog-format=row
binlog-row-image=full
max_connections=600
+default-authentication-plugin=mysql_native_password
+sql_mode=
+lower_case_table_names=1
# for mysql 8.0
secure_file_priv=/var/lib/mysql
diff --git
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
index 15a4d3136dd..9d432a4cab4 100644
---
a/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
+++
b/shardingsphere-test/shardingsphere-integration-test/shardingsphere-integration-test-suite/src/test/resources/env/postgresql/postgresql.conf
@@ -17,6 +17,7 @@
listen_addresses = '*'
wal_level = logical
+max_connections = 600
max_replication_slots = 10
log_timezone = 'Asia/Shanghai'
datestyle = 'iso, mdy'