Skip to main content
Version: Next

openGauss

openGauss is Enterprise-grade Open Source RDBMS, used for Database Management Tools Relational Databases . openGauss is an open-source relational database management system that leverages years of expertise in the database field to offer a high-reliability, high-performance, and high-security solution tailored for enterprise needs. With features like sub-10 second failover times, over 1.5 million tpmC on dual Kunpeng performance, and end-to-end security measures, openGauss is equipped with AI-based intelligent parameter tuning for easy maintenance. Join the openGauss community to explore its capabilities and contribute to its growth.

gui

Prepare​

When referring to this document to use openGauss, please read and ensure the following points:

  • Login to Websoft9 Console and find or install openGauss:

    • Go to My Apps listing applications
    • Go to App Store installing target application

  • This application is installed by Websoft9 console.

  • The purpose of this application complies with the MulanPSL-2.0 open source license agreement.

  • Configure the domain name or server security group opens external network ports for application access.

Getting started​

Connecting to the Database​

  1. After installing openGauss in the Websoft9 console, view the application details through “My Applications” and get the username and password in the “Access” tab.

  2. Enter the command mode of the openGauss container and use gsql to connect to the database:

    $ su - omm
    $ gsql -d postgres -U gaussdb
    # Get passwords in the input access tab
    Password for user gaussdb: 
    gsql ((openGauss 6.0.0 build aee4abd5) compiled at 2024-09-29 19:14:27 commit 0 last mr  )
    Non-SSL connection (SSL connection is recommended when requiring high-security)
    Type "help" for help.

    openGauss=>

Configuration options​

  • CLI: should su - omm change user to use them

    • client cli: gsql,
    • server cli: gs_ctl, gs_dump, gs_restore ...

  • pgadmin: supported, but requires a normal user login

Administer​

Troubleshooting​