jmeter访问opengauss

安装opengauss

修改配置文件

vi /opt/huawei/install/data/dn/pg_hba.conf

openGauss=# show password_encryption_type;
 password_encryption_type 
--------------------------
 2
(1 row)

openGauss=# alter system set password_encryption_type=1;
ALTER SYSTEM SET
openGauss=#

重启数据库

[omm@node1 ~]$ gs_om -t restart
Stopping cluster.
=========================================
Successfully stopped cluster.
=========================================
End stop cluster.
Starting cluster.
=========================================
[SUCCESS] node1
2023-11-24 11:31:06.792 656018fa.1 [unknown] 140438011847168 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-24 11:31:06.792 656018fa.1 [unknown] 140438011847168 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2023-11-24 11:31:06.799 656018fa.1 [unknown] 140438011847168 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (4475 Mbytes) is larger.
=========================================
Successfully started.
[omm@node1 ~]$

新建用户

openGauss=# CREATE USER xctest WITH  PASSWORD "Boray@168";
NOTICE:  The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
openGauss=# grant all privileges to xctest;
ALTER ROLE

首先建库

openGauss=# create database test;
CREATE DATABASE

Jmeter配置，需要将jar包放在jmeter的lib目录下

DataBase URL：jdbc:postgresql://192.168.30.131:15400/test?prepareThreshold=1&batchMode=on&fetchsize=10&target_session_type=master

JDBC Driver  class：org.postgresql.driver