openEuler23-09 安装openGauss 实践
【openEuler 操作系统自带版本为(openGauss 2.1.0 build )】
1.登录机器查看glibc版本
[root@openEuler23-09 ~]# ldd --version
ldd (GNU libc) 2.38
Copyright (C) 2023 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Written by Roland McGrath and Ulrich Drepper.
[root@openEuler23-09 ~]#
[root@openEuler23-09 ~]#
2.yum list 查看 openGauss
[root@openEuler23-09 ~]# yum list opengauss
OS 4.6 kB/s | 1.9 kB 00:00
everything 4.9 kB/s | 1.9 kB 00:00
EPOL 5.3 kB/s | 1.9 kB 00:00
debuginfo 4.4 kB/s | 2.4 kB 00:00
source 290 B/s | 2.2 kB 00:07
update 1.4 kB/s | 1.9 kB 00:01
update-source 6.3 kB/s | 2.4 kB 00:00
Available Packages
opengauss.src 2.1.0-5.oe2309 source
opengauss.x86_64 2.1.0-5.oe2309 OS
opengauss.x86_64 2.1.0-5.oe2309 everything
[root@openEuler23-09 ~]#
[root@openEuler23-09 ~]#
3.yum install 安装
[root@openEuler23-09 ~]# yum install opengauss -y
Last metadata expiration check: 0:05:42 ago on Thu 30 Nov 2023 06:36:55 PM CST.
Dependencies resolved.
=======================================================================================================================================
Package Architecture Version Repository Size
=======================================================================================================================================
Installing:
opengauss x86_64 2.1.0-5.oe2309 OS 14 M
Installing dependencies:
DCF x86_64 1.0.0-6.oe2309 OS 285 k
alsa-lib x86_64 1.2.9-2.oe2309 OS 463 k
boost x86_64 1.81.0-2.oe2309 OS 11 k
boost-container x86_64 1.81.0-2.oe2309 OS 41 k
boost-context x86_64 1.81.0-2.oe2309 OS 13 k
boost-contract x86_64 1.81.0-2.oe2309 OS 42 k
boost-coroutine x86_64 1.81.0-2.oe2309 OS 16 k
boost-devel x86_64 1.81.0-2.oe2309 OS 16 M
boost-fiber x86_64 1.81.0-2.oe2309 OS 36 k
boost-graph x86_64 1.81.0-2.oe2309 OS 146 k
boost-iostreams x86_64 1.81.0-2.oe2309 OS 36 k
boost-json x86_64 1.81.0-2.oe2309 OS 102 k
boost-locale x86_64 1.81.0-2.oe2309 OS 236 k
boost-log x86_64 1.81.0-2.oe2309 OS 468 k
boost-math x86_64 1.81.0-2.oe2309 OS 282 k
boost-nowide x86_64 1.81.0-2.oe2309 OS 17 k
boost-program-options x86_64 1.81.0-2.oe2309 OS 123 k
boost-python3 x86_64 1.81.0-2.oe2309 OS 97 k
boost-random x86_64 1.81.0-2.oe2309 OS 22 k
boost-regex x86_64 1.81.0-2.oe2309 OS 101 k
boost-serialization x86_64 1.81.0-2.oe2309 OS 114 k
boost-stacktrace x86_64 1.81.0-2.oe2309 OS 24 k
boost-test x86_64 1.81.0-2.oe2309 OS 235 k
boost-type_erasure x86_64 1.81.0-2.oe2309 OS 28 k
boost-url x86_64 1.81.0-2.oe2309 OS 99 k
boost-wave x86_64 1.81.0-2.oe2309 OS 203 k
cjson x86_64 1.7.15-1.oe2309 OS 28 k
cmake-filesystem x86_64 3.24.3-1.oe2309 OS 11 k
copy-jdk-configs noarch 4.0-1.oe2309 OS 27 k
emacs-filesystem noarch 1:28.2-5.oe2309 OS 7.5 k
gpm-libs x86_64 1.20.7-27.oe2309 OS 18 k
java-1.8.0-openjdk x86_64 1:1.8.0.382.b05-6.oe2309 OS 427 k
java-1.8.0-openjdk-devel x86_64 1:1.8.0.382.b05-6.oe2309 OS 9.8 M
java-1.8.0-openjdk-headless x86_64 1:1.8.0.382.b05-6.oe2309 OS 38 M
javapackages-filesystem noarch 5.3.0-5.oe2309 OS 11 k
jemalloc x86_64 5.3.0-1.oe2309 OS 215 k
jemalloc-devel x86_64 5.3.0-1.oe2309 OS 59 k
libaio-devel x86_64 0.3.113-9.oe2309 OS 10 k
libboundscheck x86_64 v1.1.11-6.oe2309 OS 46 k
libcgroup x86_64 3.1.0-2.oe2309 OS 124 k
libcgroup-devel x86_64 3.1.0-2.oe2309 OS 34 k
libcurl-devel x86_64 8.1.2-4.oe2309 OS 144 k
libedit-devel x86_64 3.1-30.oe2309 OS 14 k
libfontenc x86_64 1.1.7-1.oe2309 OS 18 k
libtool-ltdl x86_64 2.4.7-3.oe2309 OS 32 k
lksctp-tools x86_64 1.0.19-2.oe2309 OS 61 k
lua-posix x86_64 36.1-1.oe2309 OS 100 k
lz4-devel x86_64 1.9.4-2.oe2309 OS 91 k
ncurses-devel x86_64 6.4-6.oe2309 OS 81 k
numactl-devel x86_64 2.0.16-8.oe2309 OS 25 k
protobuf x86_64 3.19.6-1.oe2309 OS 994 k
protobuf-compiler x86_64 3.19.6-1.oe2309 OS 925 k
protobuf-devel x86_64 3.19.6-1.oe2309 OS 2.6 M
snappy-devel x86_64 1.1.10-1.oe2309 OS 22 k
tzdata-java noarch 2022g-5.oe2309 OS 143 k
unixODBC x86_64 2.3.9-3.oe2309 OS 402 k
unixODBC-devel x86_64 2.3.9-3.oe2309 OS 50 k
vim-common x86_64 2:9.0-36.oe2309 OS 7.4 M
vim-enhanced x86_64 2:9.0-36.oe2309 OS 1.7 M
vim-filesystem noarch 2:9.0-36.oe2309 OS 18 k
xorg-x11-font-utils x86_64 1:7.5-44.oe2309 OS 85 k
xorg-x11-fonts-others noarch 7.5-25.oe2309 OS 7.4 M
zlib-devel x86_64 1.2.13-2.oe2309 OS 92 k
zstd-devel x86_64 1.5.5-1.oe2309 OS 55 k
Transaction Summary
=======================================================================================================================================
Install 65 Packages
Total download size: 105 M
Installed size: 540 M
Downloading Packages:
(1/65): DCF-1.0.0-6.oe2309.x86_64.rpm 204 kB/s | 285 kB 00:01
(2/65): boost-1.81.0-2.oe2309.x86_64.rpm 8.0 kB/s | 11 kB 00:01
(3/65): boost-context-1.81.0-2.oe2309.x86_64.rpm 37 kB/s | 13 kB 00:00
(4/65): boost-container-1.81.0-2.oe2309.x86_64.rpm 47 kB/s | 41 kB 00:00
(5/65): boost-contract-1.81.0-2.oe2309.x86_64.rpm 77 kB/s | 42 kB 00:00
(6/65): boost-coroutine-1.81.0-2.oe2309.x86_64.rpm 27 kB/s | 16 kB 00:00
(7/65): alsa-lib-1.2.9-2.oe2309.x86_64.rpm 160 kB/s | 463 kB 00:02
(8/65): boost-fiber-1.81.0-2.oe2309.x86_64.rpm 48 kB/s | 36 kB 00:00
(9/65): boost-iostreams-1.81.0-2.oe2309.x86_64.rpm 122 kB/s | 36 kB 00:00
(10/65): boost-graph-1.81.0-2.oe2309.x86_64.rpm 135 kB/s | 146 kB 00:01
(11/65): boost-json-1.81.0-2.oe2309.x86_64.rpm 151 kB/s | 102 kB 00:00
(12/65): boost-locale-1.81.0-2.oe2309.x86_64.rpm 317 kB/s | 236 kB 00:00
(13/65): boost-log-1.81.0-2.oe2309.x86_64.rpm
(14/65): boost-math-1.81.0-2.oe2309.x86_64.rpm
(15/65): boost-nowide-1.81.0-2.oe2309.x86_64.rpm
(16/65): boost-python3-1.81.0-2.oe2309.x86_64.rpm
(17/65): boost-random-1.81.0-2.oe2309.x86_64.rpm
(18/65): boost-program-options-1.81.0-2.oe2309.x86_64.rpm
(19/65): boost-regex-1.81.0-2.oe2309.x86_64.rpm
(20/65): boost-stacktrace-1.81.0-2.oe2309.x86_64.rpm
(21/65): boost-serialization-1.81.0-2.oe2309.x86_64.rpm
(22/65): boost-type_erasure-1.81.0-2.oe2309.x86_64.rpm
(23/65): boost-test-1.81.0-2.oe2309.x86_64.rpm
(24/65): boost-url-1.81.0-2.oe2309.x86_64.rpm
(25/65): cjson-1.7.15-1.oe2309.x86_64.rpm
(26/65): cmake-filesystem-3.24.3-1.oe2309.x86_64.rpm
(27/65): boost-wave-1.81.0-2.oe2309.x86_64.rpm
(28/65): emacs-filesystem-28.2-5.oe2309.noarch.rpm
(29/65): copy-jdk-configs-4.0-1.oe2309.noarch.rpm
(30/65): gpm-libs-1.20.7-27.oe2309.x86_64.rpm
(31/65): java-1.8.0-openjdk-1.8.0.382.b05-6.oe2309.x86_64.rpm
(32/65): java-1.8.0-openjdk-devel-1.8.0.382.b05-6.oe2309.x86_64.rpm 82 kB/s | 9.8 MB 02:01 :0
(33/65): javapackages-filesystem-5.3.0-5.oe2309.noarch.rpm 55 kB/s | 11 kB 00:00
(34/65): jemalloc-5.3.0-1.oe2309.x86_64.rpm 39 kB/s | 215 kB 00:00
(35/65): jemalloc-devel-5.3.0-1.oe2309.x86_64.rpm 43 kB/s | 59 kB 00:01
(36/65): libaio-devel-0.3.113-9.oe2309.x86_64.rpm 43 kB/s | 10 kB 00:00
(37/65): libboundscheck-v1.1.11-6.oe2309.x86_64.rpm 46 kB/s | 46 kB 00:00
(38/65): libcgroup-3.1.0-2.oe2309.x86_64.rpm 63 kB/s | 124 kB 00:00
(39/65): libcgroup-devel-3.1.0-2.oe2309.x86_64.rpm 34 kB/s | 34 kB 00:01
(40/65): libcurl-devel-8.1.2-4.oe2309.x86_64.rpm 52 kB/s | 144 kB 00:02
(41/65): libedit-devel-3.1-30.oe2309.x86_64.rpm 22 kB/s | 14 kB 00:00
(42/65): libfontenc-1.1.7-1.oe2309.x86_64.rpm 42 kB/s | 18 kB 00:00
(43/65): libtool-ltdl-2.4.7-3.oe2309.x86_64.rpm 34 kB/s | 32 kB 00:00
(44/65): lksctp-tools-1.0.19-2.oe2309.x86_64.rpm 48 kB/s | 61 kB 00:00
(45/65): lua-posix-36.1-1.oe2309.x86_64.rpm 58 kB/s | 100 kB 00:01
(46/65): lz4-devel-1.9.4-2.oe2309.x86_64.rpm 52 kB/s | 91 kB 00:01
(47/65): ncurses-devel-6.4-6.oe2309.x86_64.rpm 13 kB/s | 81 kB 00:00
(48/65): numactl-devel-2.0.16-8.oe2309.x86_64.rpm 18 kB/s | 25 kB 00:01
(49/65): boost-devel-1.81.0-2.oe2309.x86_64.rpm 96 kB/s | 16 MB 02:53
(50/65): protobuf-3.19.6-1.oe2309.x86_64.rpm 03 kB/s | 994 kB 00:09
(51/65): protobuf-compiler-3.19.6-1.oe2309.x86_64.rpm 15 kB/s | 925 kB 00:04
(52/65): protobuf-devel-3.19.6-1.oe2309.x86_64.rpm 11 kB/s | 2.6 MB 00:24
(53/65): snappy-devel-1.1.10-1.oe2309.x86_64.rpm 32 kB/s | 22 kB 00:00
(54/65): tzdata-java-2022g-5.oe2309.noarch.rpm 54 kB/s | 143 kB 00:00
(55/65): unixODBC-2.3.9-3.oe2309.x86_64.rpm 73 kB/s | 402 kB 00:05
(56/65): unixODBC-devel-2.3.9-3.oe2309.x86_64.rpm 29 kB/s | 50 kB 00:01
(57/65): opengauss-2.1.0-5.oe2309.x86_64.rpm 92 kB/s | 14 MB 02:32
(58/65): vim-common-9.0-36.oe2309.x86_64.rpm 84 kB/s | 7.4 MB 01:30
(59/65): vim-filesystem-9.0-36.oe2309.noarch.rpm 26 kB/s | 18 kB 00:00
(60/65): xorg-x11-font-utils-7.5-44.oe2309.x86_64.rpm 47 kB/s | 85 kB 00:01
(61/65): vim-enhanced-9.0-36.oe2309.x86_64.rpm 66 kB/s | 1.7 MB 00:25
(62/65): zlib-devel-1.2.13-2.oe2309.x86_64.rpm 56 kB/s | 92 kB 00:01
(63/65): zstd-devel-1.5.5-1.oe2309.x86_64.rpm 84 kB/s | 55 kB 00:00
(64/65): xorg-x11-fonts-others-7.5-25.oe2309.noarch.rpm 98 kB/s | 7.4 MB 01:16
(65/65): java-1.8.0-openjdk-headless-1.8.0.382.b05-6.oe2309.x86_64.rpm 02 kB/s | 38 MB 06:24
---------------------------------------------------------------------------------------------------------------------------------------
Total 63 kB/s | 105 MB 06:47
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Running scriptlet: copy-jdk-configs-4.0-1.oe2309.noarch 1/1
Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.382.b05-6.oe2309.x86_64 1/1
Preparing : 1/1
Installing : boost-regex-1.81.0-2.oe2309.x86_64 1/65
Installing : boost-context-1.81.0-2.oe2309.x86_64 2/65
Installing : protobuf-3.19.6-1.oe2309.x86_64 3/65
Running scriptlet: libcgroup-3.1.0-2.oe2309.x86_64 4/65
Installing : libcgroup-3.1.0-2.oe2309.x86_64 4/65
Installing : libboundscheck-v1.1.11-6.oe2309.x86_64 5/65
Running scriptlet: libboundscheck-v1.1.11-6.oe2309.x86_64 5/65
Installing : jemalloc-5.3.0-1.oe2309.x86_64 6/65
Running scriptlet: jemalloc-5.3.0-1.oe2309.x86_64 6/65
Installing : boost-container-1.81.0-2.oe2309.x86_64 7/65
Installing : boost-json-1.81.0-2.oe2309.x86_64 8/65
Installing : jemalloc-devel-5.3.0-1.oe2309.x86_64 9/65
Installing : libcgroup-devel-3.1.0-2.oe2309.x86_64 10/65
Installing : boost-coroutine-1.81.0-2.oe2309.x86_64 11/65
Installing : boost-fiber-1.81.0-2.oe2309.x86_64 12/65
Installing : boost-graph-1.81.0-2.oe2309.x86_64 13/65
Installing : boost-log-1.81.0-2.oe2309.x86_64 14/65
Installing : zstd-devel-1.5.5-1.oe2309.x86_64 15/65
Installing : zlib-devel-1.2.13-2.oe2309.x86_64 16/65
Installing : vim-filesystem-2:9.0-36.oe2309.noarch 17/65
Installing : vim-common-2:9.0-36.oe2309.x86_64 18/65
Installing : tzdata-java-2022g-5.oe2309.noarch 19/65
Installing : numactl-devel-2.0.16-8.oe2309.x86_64 20/65
Installing : ncurses-devel-6.4-6.oe2309.x86_64 21/65
Installing : libedit-devel-3.1-30.oe2309.x86_64 22/65
Installing : lz4-devel-1.9.4-2.oe2309.x86_64 23/65
Installing : lua-posix-36.1-1.oe2309.x86_64 24/65
Installing : copy-jdk-configs-4.0-1.oe2309.noarch 25/65
Running scriptlet: lksctp-tools-1.0.19-2.oe2309.x86_64 26/65
Installing : lksctp-tools-1.0.19-2.oe2309.x86_64 26/65
Running scriptlet: lksctp-tools-1.0.19-2.oe2309.x86_64 26/65
Installing : libtool-ltdl-2.4.7-3.oe2309.x86_64 27/65
Installing : unixODBC-2.3.9-3.oe2309.x86_64 28/65
Running scriptlet: unixODBC-2.3.9-3.oe2309.x86_64 28/65
Installing : unixODBC-devel-2.3.9-3.oe2309.x86_64 29/65
Installing : libfontenc-1.1.7-1.oe2309.x86_64 30/65
Installing : xorg-x11-font-utils-1:7.5-44.oe2309.x86_64 31/65
Installing : xorg-x11-fonts-others-7.5-25.oe2309.noarch 32/65
Running scriptlet: xorg-x11-fonts-others-7.5-25.oe2309.noarch 32/65
Installing : libcurl-devel-8.1.2-4.oe2309.x86_64 33/65
Installing : libaio-devel-0.3.113-9.oe2309.x86_64 34/65
Installing : javapackages-filesystem-5.3.0-5.oe2309.noarch 35/65
Installing : java-1.8.0-openjdk-headless-1:1.8.0.382.b05-6.oe2309.x86_64 36/65
Running scriptlet: java-1.8.0-openjdk-headless-1:1.8.0.382.b05-6.oe2309.x86_64 36/65
Installing : gpm-libs-1.20.7-27.oe2309.x86_64 37/65
Installing : vim-enhanced-2:9.0-36.oe2309.x86_64 38/65
Installing : emacs-filesystem-1:28.2-5.oe2309.noarch 39/65
Installing : protobuf-compiler-3.19.6-1.oe2309.x86_64 40/65
Installing : protobuf-devel-3.19.6-1.oe2309.x86_64 41/65
Installing : cmake-filesystem-3.24.3-1.oe2309.x86_64 42/65
Installing : snappy-devel-1.1.10-1.oe2309.x86_64 43/65
Installing : cjson-1.7.15-1.oe2309.x86_64 44/65
Running scriptlet: cjson-1.7.15-1.oe2309.x86_64 44/65
Installing : DCF-1.0.0-6.oe2309.x86_64 45/65
Running scriptlet: DCF-1.0.0-6.oe2309.x86_64 45/65
Installing : boost-wave-1.81.0-2.oe2309.x86_64 46/65
Installing : boost-url-1.81.0-2.oe2309.x86_64 47/65
Installing : boost-type_erasure-1.81.0-2.oe2309.x86_64 48/65
Installing : boost-test-1.81.0-2.oe2309.x86_64 49/65
Installing : boost-stacktrace-1.81.0-2.oe2309.x86_64 50/65
Installing : boost-serialization-1.81.0-2.oe2309.x86_64 51/65
Installing : boost-random-1.81.0-2.oe2309.x86_64 52/65
Installing : boost-python3-1.81.0-2.oe2309.x86_64 53/65
Installing : boost-program-options-1.81.0-2.oe2309.x86_64 54/65
Installing : boost-nowide-1.81.0-2.oe2309.x86_64 55/65
Installing : boost-math-1.81.0-2.oe2309.x86_64 56/65
Installing : boost-locale-1.81.0-2.oe2309.x86_64 57/65
Installing : boost-iostreams-1.81.0-2.oe2309.x86_64 58/65
Installing : boost-contract-1.81.0-2.oe2309.x86_64 59/65
Installing : boost-1.81.0-2.oe2309.x86_64 60/65
Installing : boost-devel-1.81.0-2.oe2309.x86_64 61/65
Installing : alsa-lib-1.2.9-2.oe2309.x86_64 62/65
Installing : java-1.8.0-openjdk-1:1.8.0.382.b05-6.oe2309.x86_64 63/65
Running scriptlet: java-1.8.0-openjdk-1:1.8.0.382.b05-6.oe2309.x86_64 63/65
Installing : java-1.8.0-openjdk-devel-1:1.8.0.382.b05-6.oe2309.x86_64 64/65
Running scriptlet: java-1.8.0-openjdk-devel-1:1.8.0.382.b05-6.oe2309.x86_64 64/65
Running scriptlet: opengauss-2.1.0-5.oe2309.x86_64 65/65
Installing : opengauss-2.1.0-5.oe2309.x86_64 65/65
Running scriptlet: opengauss-2.1.0-5.oe2309.x86_64 65/65
Created symlink /etc/systemd/system/multi-user.target.wants/opengauss.service → /usr/lib/systemd/system/opengauss.service.
Init openGauss database success.
Start openGauss database success.
Running scriptlet: copy-jdk-configs-4.0-1.oe2309.noarch 65/65
Running scriptlet: java-1.8.0-openjdk-1:1.8.0.382.b05-6.oe2309.x86_64 65/65
Running scriptlet: java-1.8.0-openjdk-devel-1:1.8.0.382.b05-6.oe2309.x86_64 65/65
Running scriptlet: opengauss-2.1.0-5.oe2309.x86_64 65/65
Running scriptlet: vim-common-2:9.0-36.oe2309.x86_64 65/65
Verifying : DCF-1.0.0-6.oe2309.x86_64 1/65
Verifying : alsa-lib-1.2.9-2.oe2309.x86_64 2/65
Verifying : boost-1.81.0-2.oe2309.x86_64 3/65
Verifying : boost-container-1.81.0-2.oe2309.x86_64 4/65
Verifying : boost-context-1.81.0-2.oe2309.x86_64 5/65
Verifying : boost-contract-1.81.0-2.oe2309.x86_64 6/65
Verifying : boost-coroutine-1.81.0-2.oe2309.x86_64 7/65
Verifying : boost-devel-1.81.0-2.oe2309.x86_64 8/65
Verifying : boost-fiber-1.81.0-2.oe2309.x86_64 9/65
Verifying : boost-graph-1.81.0-2.oe2309.x86_64 10/65
Verifying : boost-iostreams-1.81.0-2.oe2309.x86_64 11/65
Verifying : boost-json-1.81.0-2.oe2309.x86_64 12/65
Verifying : boost-locale-1.81.0-2.oe2309.x86_64 13/65
Verifying : boost-log-1.81.0-2.oe2309.x86_64 14/65
Verifying : boost-math-1.81.0-2.oe2309.x86_64 15/65
Verifying : boost-nowide-1.81.0-2.oe2309.x86_64 16/65
Verifying : boost-program-options-1.81.0-2.oe2309.x86_64 17/65
Verifying : boost-python3-1.81.0-2.oe2309.x86_64 18/65
Verifying : boost-random-1.81.0-2.oe2309.x86_64 19/65
Verifying : boost-regex-1.81.0-2.oe2309.x86_64 20/65
Verifying : boost-serialization-1.81.0-2.oe2309.x86_64 21/65
Verifying : boost-stacktrace-1.81.0-2.oe2309.x86_64 22/65
Verifying : boost-test-1.81.0-2.oe2309.x86_64 23/65
Verifying : boost-type_erasure-1.81.0-2.oe2309.x86_64 24/65
Verifying : boost-url-1.81.0-2.oe2309.x86_64 25/65
Verifying : boost-wave-1.81.0-2.oe2309.x86_64 26/65
Verifying : cjson-1.7.15-1.oe2309.x86_64 27/65
Verifying : cmake-filesystem-3.24.3-1.oe2309.x86_64 28/65
Verifying : copy-jdk-configs-4.0-1.oe2309.noarch 29/65
Verifying : emacs-filesystem-1:28.2-5.oe2309.noarch 30/65
Verifying : gpm-libs-1.20.7-27.oe2309.x86_64 31/65
Verifying : java-1.8.0-openjdk-1:1.8.0.382.b05-6.oe2309.x86_64 32/65
Verifying : java-1.8.0-openjdk-devel-1:1.8.0.382.b05-6.oe2309.x86_64 33/65
Verifying : java-1.8.0-openjdk-headless-1:1.8.0.382.b05-6.oe2309.x86_64 34/65
Verifying : javapackages-filesystem-5.3.0-5.oe2309.noarch 35/65
Verifying : jemalloc-5.3.0-1.oe2309.x86_64 36/65
Verifying : jemalloc-devel-5.3.0-1.oe2309.x86_64 37/65
Verifying : libaio-devel-0.3.113-9.oe2309.x86_64 38/65
Verifying : libboundscheck-v1.1.11-6.oe2309.x86_64 39/65
Verifying : libcgroup-3.1.0-2.oe2309.x86_64 40/65
Verifying : libcgroup-devel-3.1.0-2.oe2309.x86_64 41/65
Verifying : libcurl-devel-8.1.2-4.oe2309.x86_64 42/65
Verifying : libedit-devel-3.1-30.oe2309.x86_64 43/65
Verifying : libfontenc-1.1.7-1.oe2309.x86_64 44/65
Verifying : libtool-ltdl-2.4.7-3.oe2309.x86_64 45/65
Verifying : lksctp-tools-1.0.19-2.oe2309.x86_64 46/65
Verifying : lua-posix-36.1-1.oe2309.x86_64 47/65
Verifying : lz4-devel-1.9.4-2.oe2309.x86_64 48/65
Verifying : ncurses-devel-6.4-6.oe2309.x86_64 49/65
Verifying : numactl-devel-2.0.16-8.oe2309.x86_64 50/65
Verifying : opengauss-2.1.0-5.oe2309.x86_64 51/65
Verifying : protobuf-3.19.6-1.oe2309.x86_64 52/65
Verifying : protobuf-compiler-3.19.6-1.oe2309.x86_64 53/65
Verifying : protobuf-devel-3.19.6-1.oe2309.x86_64 54/65
Verifying : snappy-devel-1.1.10-1.oe2309.x86_64 55/65
Verifying : tzdata-java-2022g-5.oe2309.noarch 56/65
Verifying : unixODBC-2.3.9-3.oe2309.x86_64 57/65
Verifying : unixODBC-devel-2.3.9-3.oe2309.x86_64 58/65
Verifying : vim-common-2:9.0-36.oe2309.x86_64 59/65
Verifying : vim-enhanced-2:9.0-36.oe2309.x86_64 60/65
Verifying : vim-filesystem-2:9.0-36.oe2309.noarch 61/65
Verifying : xorg-x11-font-utils-1:7.5-44.oe2309.x86_64 62/65
Verifying : xorg-x11-fonts-others-7.5-25.oe2309.noarch 63/65
Verifying : zlib-devel-1.2.13-2.oe2309.x86_64 64/65
Verifying : zstd-devel-1.5.5-1.oe2309.x86_64 65/65
Installed:
DCF-1.0.0-6.oe2309.x86_64 alsa-lib-1.2.9-2.oe2309.x86_64
boost-1.81.0-2.oe2309.x86_64 boost-container-1.81.0-2.oe2309.x86_64
boost-context-1.81.0-2.oe2309.x86_64 boost-contract-1.81.0-2.oe2309.x86_64
boost-coroutine-1.81.0-2.oe2309.x86_64 boost-devel-1.81.0-2.oe2309.x86_64
boost-fiber-1.81.0-2.oe2309.x86_64 boost-graph-1.81.0-2.oe2309.x86_64
boost-iostreams-1.81.0-2.oe2309.x86_64 boost-json-1.81.0-2.oe2309.x86_64
boost-locale-1.81.0-2.oe2309.x86_64 boost-log-1.81.0-2.oe2309.x86_64
boost-math-1.81.0-2.oe2309.x86_64 boost-nowide-1.81.0-2.oe2309.x86_64
boost-program-options-1.81.0-2.oe2309.x86_64 boost-python3-1.81.0-2.oe2309.x86_64
boost-random-1.81.0-2.oe2309.x86_64 boost-regex-1.81.0-2.oe2309.x86_64
boost-serialization-1.81.0-2.oe2309.x86_64 boost-stacktrace-1.81.0-2.oe2309.x86_64
boost-test-1.81.0-2.oe2309.x86_64 boost-type_erasure-1.81.0-2.oe2309.x86_64
boost-url-1.81.0-2.oe2309.x86_64 boost-wave-1.81.0-2.oe2309.x86_64
cjson-1.7.15-1.oe2309.x86_64 cmake-filesystem-3.24.3-1.oe2309.x86_64
copy-jdk-configs-4.0-1.oe2309.noarch emacs-filesystem-1:28.2-5.oe2309.noarch
gpm-libs-1.20.7-27.oe2309.x86_64 java-1.8.0-openjdk-1:1.8.0.382.b05-6.oe2309.x86_64
java-1.8.0-openjdk-devel-1:1.8.0.382.b05-6.oe2309.x86_64 java-1.8.0-openjdk-headless-1:1.8.0.382.b05-6.oe2309.x86_64
javapackages-filesystem-5.3.0-5.oe2309.noarch jemalloc-5.3.0-1.oe2309.x86_64
jemalloc-devel-5.3.0-1.oe2309.x86_64 libaio-devel-0.3.113-9.oe2309.x86_64
libboundscheck-v1.1.11-6.oe2309.x86_64 libcgroup-3.1.0-2.oe2309.x86_64
libcgroup-devel-3.1.0-2.oe2309.x86_64 libcurl-devel-8.1.2-4.oe2309.x86_64
libedit-devel-3.1-30.oe2309.x86_64 libfontenc-1.1.7-1.oe2309.x86_64
libtool-ltdl-2.4.7-3.oe2309.x86_64 lksctp-tools-1.0.19-2.oe2309.x86_64
lua-posix-36.1-1.oe2309.x86_64 lz4-devel-1.9.4-2.oe2309.x86_64
ncurses-devel-6.4-6.oe2309.x86_64 numactl-devel-2.0.16-8.oe2309.x86_64
opengauss-2.1.0-5.oe2309.x86_64 protobuf-3.19.6-1.oe2309.x86_64
protobuf-compiler-3.19.6-1.oe2309.x86_64 protobuf-devel-3.19.6-1.oe2309.x86_64
snappy-devel-1.1.10-1.oe2309.x86_64 tzdata-java-2022g-5.oe2309.noarch
unixODBC-2.3.9-3.oe2309.x86_64 unixODBC-devel-2.3.9-3.oe2309.x86_64
vim-common-2:9.0-36.oe2309.x86_64 vim-enhanced-2:9.0-36.oe2309.x86_64
vim-filesystem-2:9.0-36.oe2309.noarch xorg-x11-font-utils-1:7.5-44.oe2309.x86_64
xorg-x11-fonts-others-7.5-25.oe2309.noarch zlib-devel-1.2.13-2.oe2309.x86_64
zstd-devel-1.5.5-1.oe2309.x86_64
Complete!
[root@openEuler23-09 ~]#
4.切换到openGauss用户
[root@openEuler23-09 ~]# su - opengauss
Last login: Thu Nov 30 18:50:06 CST 2023
Welcome to 6.4.0-10.1.0.20.oe2309.x86_64
System information as of time: Thu Nov 30 06:54:00 PM CST 2023
System load: 0.01
Processes: 167
Memory used: 11.6%
Swap used: 2.6%
Usage On: 20%
IP address: 192.168.158.129
Users online: 3
To run a command as administrator(user "root"),use "sudo <command>".
Welcome to 6.4.0-10.1.0.20.oe2309.x86_64
System information as of time: Thu Nov 30 06:54:00 PM CST 2023
System load: 0.01
Processes: 167
Memory used: 11.7%
Swap used: 2.6%
Usage On: 20%
IP address: 192.168.158.129
Users online: 3
To run a command as administrator(user "root"),use "sudo <command>".
[opengauss@openEuler23-09 ~]$
5.查看进程
[opengauss@openEuler23-09 ~]$ ps -ux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
opengau+ 4095 1.0 6.4 1794536 221564 ? Sl 18:50 0:02 /usr/local/opengauss/bin/gaussdb -D /var/lib/opengauss/data
opengau+ 4184 0.0 0.1 23296 4096 pts/1 S 18:54 0:00 -bash
opengau+ 4314 0.0 0.1 27748 5632 pts/1 R+ 18:54 0:00 ps -ux
[opengauss@openEuler23-09 ~]$
6.查看监听端口
[opengauss@openEuler23-09 ~]$ netstat -nlp|grep gauss
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 127.0.0.1:7655 0.0.0.0:* LISTEN 1462/gaussdb
tcp 0 0 127.0.0.1:7654 0.0.0.0:* LISTEN 1462/gaussdb
tcp6 0 0 ::1:7655 :::* LISTEN 1462/gaussdb
tcp6 0 0 ::1:7654 :::* LISTEN 1462/gaussdb
unix 2 [ ACC ] STREAM LISTENING 23248 1462/gaussdb /tmp/.s.PGSQL.7654
unix 2 [ ACC ] STREAM LISTENING 23249 1462/gaussdb /tmp/.s.PGSQL.7655
[opengauss@openEuler23-09 ~]$
7.使用gsql连接opengauss实例
[opengauss@openEuler23-09 ~]$ gsql -d postgres -p 7654 -r
gsql ((openGauss 2.1.0 build ) compiled at 2023-09-21 23:57:13 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=# \l
ERROR: Please use "ALTER ROLE user_name PASSWORD 'password';" to set the password of user opengauss before other operation!
openGauss=#
openGauss=# ALTER ROLE opengauss PASSWORD 'Test@1234';
ALTER ROLE
openGauss=#
openGauss=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-----------+----------+-------------+-------------+-------------------------
postgres | opengauss | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | opengauss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/opengauss +
| | | | | opengauss=CTc/opengauss
template1 | opengauss | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/opengauss +
| | | | | opengauss=CTc/opengauss
(3 rows)
openGauss=# \d
No relations found.
openGauss=#
openGauss=# select version();
version
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(openGauss 2.1.0 build ) compiled at 2023-09-21 23:57:13 commit 0 last mr on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 12.3.1 (openEuler 12.3.1-16.oe2309), 64-bit
(1 row)
openGauss=# \dn
List of schemas
Name | Owner
----------------+-----------
blockchain | opengauss
cstore | opengauss
db4ai | opengauss
dbe_perf | opengauss
dbe_pldebugger | opengauss
pkg_service | opengauss
public | opengauss
snapshot | opengauss
sqladvisor | opengauss
(9 rows)
openGauss=# \ds
No relations found.
openGauss=# \q
[opengauss@openEuler23-09 ~]$
8.创建tpcc用户和库、schema
openGauss=#
openGauss=# create user tpcc with password 'Test@1234';
CREATE ROLE
openGauss=# create database tpcc owner tpcc;
CREATE DATABASE
openGauss=# \q
[opengauss@localhost ~]$ gsql -dtpcc -p 7654
gsql ((openGauss 2.1.0 build ) compiled at 2023-09-21 23:57:13 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
tpcc=# \q
[opengauss@localhost ~]$ gsql -Utpcc -dtpcc -p 7654
Password for user tpcc:
gsql ((openGauss 2.1.0 build ) compiled at 2023-09-21 23:57:13 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
tpcc=>
tpcc=>
tpcc=> \dn
List of schemas
Name | Owner
----------------+-------
blockchain |
cstore |
db4ai |
dbe_perf |
dbe_pldebugger |
pkg_service |
public |
snapshot |
sqladvisor |
(9 rows)
tpcc=> \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------+----------+-------------+-------------+-------------------------
postgres | | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/opengauss +
| | | | | opengauss=CTc/opengauss
template1 | | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/opengauss +
| | | | | opengauss=CTc/opengauss
tpcc | tpcc | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(4 rows)
tpcc=> create schema tpcc;
CREATE SCHEMA
tpcc=>
tpcc=> \dn
List of schemas
Name | Owner
----------------+-------
blockchain |
cstore |
db4ai |
dbe_perf |
dbe_pldebugger |
pkg_service |
public |
snapshot |
sqladvisor |
tpcc | tpcc
(10 rows)
tpcc=>
tpcc=>