opengauss5.0+postgis2.4.2的安装小记

openGauss=# create database tjyd encoding='UTF-8' LC_COLLATE='zh_CN.UTF-8' LC_CTYPE='zh_CN.UTF-8' DBCOMPATIBILITY='A';
CREATE DATABASE
openGauss=# create user gistar identified by 'xxxxxx';
CREATE ROLE
openGauss=# grant all privileges to gistar;
ALTER ROLE
openGauss=# du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------------------------------------------------------------+-----------
gistar | Sysadmin | {}
omm | Sysadmin, Create role, Create DB, Replication, Administer audit, Monitoradmin, Operatoradmin, Policyadmin, UseFT | {}

openGauss=# q
[omm@openGauss ~]$ gsql -d tjyd -p 15400 -U gistar -W xxxxxx -r
gsql ((openGauss 5.0.1 build 33b035fd) compiled at 2023-12-15 20:19:06 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

tjyd=> create table test(id int);
CREATE TABLE
tjyd=> insert into test values(1);
INSERT 0 1
tjyd=> select * from test;
id
----
1
(1 row)

tjyd=> dt
List of relations
Schema | Name | Type | Owner | Storage
--------+------+-------+--------+----------------------------------
public | test | table | gistar | {orientation=row,compression=no}
(1 row)

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

# "local" is for Unix domain socket connections only
local all all trust
host all omm 192.168.207.194/32 trust
#host all all 0.0.0.0/0 trust
# IPv4 local connections:
#host all all 127.0.0.1/32 trust
#host all all 192.168.207.194/16 sha256
host all all 0.0.0.0/0 sha256

# IPv6 local connections:
host all all ::1/128 trust
host all all 0.0.0.0/0 sha256
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication omm trust
#host replication omm 127.0.0.1/32 trust
#host replication omm ::1/128 trust
"/opt/huawei/install/data/dn/pg_hba.conf" 105L, 4681C written
[omm@openGauss ~]$ gsql -h 192.168.207.194 -d tjyd -p 15400 -U gistar -W xxxxxx -r
gsql: FATAL: Forbid remote connection with trust method!
FATAL: Forbid remote connection with trust method!
[omm@openGauss ~]$ gs_om -t restart
Stopping cluster.
=========================================
Successfully stopped cluster.
=========================================
End stop cluster.
Starting cluster.
=========================================
[SUCCESS] openGauss
2024-02-29 15:59:49.225 65e03975.1 [unknown] 140064104145216 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-29 15:59:49.225 65e03975.1 [unknown] 140064104145216 [unknown] 0 dn_6001 01000 0 [BACKEND] WARNING: could not create any HA TCP/IP sockets
2024-02-29 15:59:49.226 65e03975.1 [unknown] 140064104145216 [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 (4476 Mbytes) is larger.
=========================================
Successfully started.
[omm@openGauss ~]$ gsql -h 192.168.207.194 -d tjyd -p 15400 -U gistar -W xxxxxx -r
gsql ((openGauss 5.0.1 build 33b035fd) compiled at 2023-12-15 20:19:06 commit 0 last mr )
SSL connection (cipher: ECDHE-RSA-AES128-GCM-SHA256, bits: 128)
Type "help" for help.

tjyd=>
[omm@openGauss ~]$ gsql -d tjyd -p 15400 -W xxxxxx -r
gsql ((openGauss 5.0.1 build 33b035fd) compiled at 2023-12-15 20:19:06 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

tjyd=# dx
List of installed extensions
Name | Version | Schema | Description
-----------------+---------+------------+--------------------------------------------------
dist_fdw | 1.0 | pg_catalog | foreign-data wrapper for distfs access
file_fdw | 1.0 | pg_catalog | foreign-data wrapper for flat file access
hstore | 1.1 | pg_catalog | data type for storing sets of (key, value) pairs
log_fdw | 1.0 | pg_catalog | Foreign Data Wrapper for accessing logging data
mot_fdw | 1.0 | pg_catalog | foreign-data wrapper for MOT access
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
security_plugin | 1.0 | pg_catalog | provides security functionality
(7 rows)

tjyd=# create extension postgis;
CREATE EXTENSION
tjyd=# dx
List of installed extensions
Name | Version | Schema | Description
-----------------+---------+------------+---------------------------------------------------------------------
dist_fdw | 1.0 | pg_catalog | foreign-data wrapper for distfs access
file_fdw | 1.0 | pg_catalog | foreign-data wrapper for flat file access
hstore | 1.1 | pg_catalog | data type for storing sets of (key, value) pairs
log_fdw | 1.0 | pg_catalog | Foreign Data Wrapper for accessing logging data
mot_fdw | 1.0 | pg_catalog | foreign-data wrapper for MOT access
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
postgis | 2.4.2 | public | PostGIS geometry, geography, and raster spatial types and functions
security_plugin | 1.0 | pg_catalog | provides security functionality
(8 rows)

tjyd=# c
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "tjyd" as user "omm".
tjyd=#
tjyd=# q
[omm@openGauss ~]$ df -hT
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 16G 0 16G 0% /dev
tmpfs tmpfs 16G 12K 16G 1% /dev/shm
tmpfs tmpfs 16G 8.9M 16G 1% /run
tmpfs tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/mapper/centos-root xfs 81G 13G 69G 16% /
/dev/sda1 xfs 1014M 168M 847M 17% /boot
/dev/mapper/centos-home xfs 10G 33M 10G 1% /home
tmpfs tmpfs 3.2G 0 3.2G 0% /run/user/0