Photo by Marcus Loke on Unsplash A new table contains no data. You need to insert data to the table before using it. You can execute the INSERT INTO statement to insert data into the table. …

Photo by Mika Baumeister on Unsplash Create an empty table in the current database. The table will be owned by the creator. The same table can be stored in different databases. You can execute the CREATE TABLE statement to create a table. Syntax Copy CodeCREATE TABLE table_name…

Photo by Jan Antonin Kolar on Unsplash After the database is installed, a database named postgres is generated by default. You need to create your own database. Syntax Create a database. Copy CodeCREATE DATABASE database_name; View the database. Run \l to view the existing database. Copy Code\l Run \c + Database…

openGauss is a relational database management system (RDBMS). A relational database organizes data using a relational model, that is, data is stored in rows and columns. openGauss database nodes store data on disks. Logically, objects on a database node include tablespaces, databases, datafile segments, tables, and blocks. …

Photo by Sigmund on Unsplash Create a user group dbgroup. Copy Codegroupadd dbgroup 2. Create a common user omm in the dbgroup user group and set the password to Gauss_234. Copy Codeuseradd -g dbgroup omm passwd Gauss_234 3. Log in to the host where the package is installed as user…

Photo by Bill Mead on Unsplash Create a user group dbgroup. Copy Codegroupadd dbgroup 2. Create a common user omm in the dbgroup user group and set the password to Gauss_234. Copy Codeuseradd -g dbgroup omm passwd Gauss_234 3. Log in to the host where the openGauss package is installed…

Photo by Christian Wiediger on Unsplash This section describes the preparations for installation. It is recommended that servers to be deployed on openGauss have the same software and hardware configurations. Hardware requirements Fellow lists the minimum hardware requirements of the openGauss server. When planning the hardware configuration of a product, consider the…

openGauss is a standalone system that supports one primary and up to eight standby servers. Service data is stored on a single physical node, and data access tasks are pushed to service nodes and then executed. The high concurrency of servers enables quick response to data processing. …

Photo by Mildlee on Unsplash Procedure Download the installation package of the corresponding platform from the openGauss community. Log in to the openGauss community and download the latest installation package of the corresponding platform. …