DEV Community

Lei Zhou
Lei Zhou

Posted on

openGauss Study notes (0001)

Why: why I want to choose a new database

The motivation is very simple, I do not know what is the most benefits why openGauss want to create a new relational database, so I want to try to feagure out it.

What: What's is openGauss

openGauss is a relational database[1], which is donated by Huawei, and which adopts client/server, single-process and multi-threaded architecture; it supports stand-alone and one-master-multiple-standby deployment methods, and supports features such as readability of standby machines and high availability of dual machines.
It's derived from PostgreSQL.

What's the difference between openGauss and PostgreSQL

A lot of China Company started to use it.
openGauss is based on PostgreSQL 9.2.4[2], and has the threads pool. and support huge number of transactions.

How to use it 

su - omm #use omm user to login OS.
Enter fullscreen mode Exit fullscreen mode

start the server

gs_om -t stop   #stop the service
gs_om -t start  #strat the service
Enter fullscreen mode Exit fullscreen mode

check the status

gs_om -t status --detail
Enter fullscreen mode Exit fullscreen mode

check the performance of DB

gs_checkperf  #gs_checkperf -i pmk -U omm [--detai]
Enter fullscreen mode Exit fullscreen mode

the ports of DB

cat /opt/gaussdb/master1/postgresql.conf |grep port
Enter fullscreen mode Exit fullscreen mode

list all of the Databases

gsql -d postgres -p 36000 -l
Enter fullscreen mode Exit fullscreen mode

SQL

Create Database users

create user jack password "******";
Enter fullscreen mode Exit fullscreen mode
  1. What's openGauss, https://docs.opengauss.org/en/docs/3.1.1/docs/BriefTutorial/what-is-opengauss.html
  2. openGauss is based on PostgreSQL 9.2.4, https://zhuanlan.zhihu.com/p/449917123

Top comments (0)