(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) 2020-11-12 16:38:11.745 [unknown] [unknown] localhost 139911881094272 0 0 [BACKEND] FATAL: could not create listen socket for "192.167.1.67:5432"...
LOG: could not bind socket at the 10 time, is another postmaster already running on port 54000? 处理办法:执行如下命令查看侦听该端口的进程。端口号请根据实际端口号替换。 [root@openGauss36 ~]# netstat -anop | grep 15970 tcp 0 0 127.0.0.1:15970 0.0.0.0:* LISTEN 3920251/gaussdb off (0.00/...
[opengauss@VM-12-13-centos ~]$ gsql -d hello -p 5432 -U dbAdmin -r Password for user dbAdmin: gsql: FATAL: could not load library "dblink.so": libltdl.so.7: cannot open shared object file: No such file or directory CONTEXT: SQL statement "create extension if not exists dblink;"...
2023-07-22 16:21:31.942 64bb918b.1 [unknown] 139874136903616 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2023-07-22 16:21:31.945 64bb918b.1 [unknown] 139874136903616 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: Failed to initialize the ...
{ local arg count=1 for arg; do case "$arg" in # postgres --help | grep 'then exit' # leaving out -C on purpose since it always fails and is unhelpful: # postgres: could not access the server configuration file "/var/lib/postgresql/data/postgresql.conf": No such file or ...
# 修改目录权限后,切换到普通用户,否则会提示:Error:can not install openGausswithroot sh install.sh-w omm@1234 上述命令中,-w是指初始化数据库密码(gs_initdb指定),安全需要必须设置。 centos7.8报sem不足: sysctl-w kernel.sem="250 85000 250 330" ...
LOG: could not bind socket at the 10 time, is another postmaster already running on port 54000? **处理办法**:执行如下命令查看侦听该端口的进程。端口号请根据实际端口号替换。 [root@openGauss36 ~]# netstat -anop | grep 15970 tcp 0 0 127.0.0.1:15970 0.0.0.0:* LISTEN 3920251/gaussdb off ...
FATAL:hot standbyisnot possible because max_connections=10isa lower setting than on the master server(itsvaluewas100) 检查GUC参数配置的合理性。例如,shared_buffers、effective_cache_size、bulk_write_ring_size等消耗资源过大的参数;或max_connections等增加后不容易减少的参数。GUC参数的查看及设置方法,详情...
Type "help" for help. openGauss=# create user testuser password 'openGauss!666'; NOTICE: The encrypted password contains MD5 ciphertext, which is not secure. CREATE ROLE 1. 2. 3. 4. 5. 6. 7. 8. 防火墙开放端口 防火墙为未启动状态,略过此步骤; ...
2023-07-22 16:21:31.942 64bb918b.1 [unknown] 139874136903616 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets 2023-07-22 16:21:31.945 64bb918b.1 [unknown] 139874136903616 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: Failed to initialize the...