🚀 KubeSphere 3.1.1 is now available as it extends Kubernetes from the cloud to the edge. Read the introduction for 3.1.x → close
  • English
    • English
    • 简体中文
    1. 1.Experience account: demo1 / Demo123
    2. 2.This account is only allowed to view parts of UI
    3. 3.It's recommended that install KubeSphere in your environment
  •  Star
  1. Documentation / 
  2. App Store / 
  3. Built-in Applications / 
  4. Deploy RadonDB PostgreSQL on KubeSphere

App Store

Last updated:
    Edit

    Deploy RadonDB PostgreSQL on KubeSphere

    RadonDB PostgreSQL is an open source, cloud-native, and highly available cluster solution based on PostgreSQL database system.

    This tutorial demonstrates how to deploy RadonDB PostgreSQL from the App Store of KubeSphere.

    Prerequisites

    • Please make sure you enable the OpenPitrix system.
    • You need to create a workspace, a project, and a user account (project-regular) for this tutorial. The account needs to be a platform regular user and to be invited as the project operator with the operator role. In this tutorial, you log in as project-regular and work in the project demo-project in the workspace demo-workspace. For more information, see Create Workspaces, Projects, Accounts and Roles.

    Hands-on Lab

    Step 1: Deploy RadonDB PostgreSQL from the App Store

    1. On the Overview page of the project demo-project, click App Store in the upper-left corner.

    2. Click Database & Cache under Categories.

      RadonDB PostgreSQL-in-app-store

    3. Find RadonDB PostgreSQL and click Deploy on the App Information page.

      deploy-RadonDB PostgreSQL

    4. Set a name and select an app version. Make sure RadonDB PostgreSQL is deployed in demo-project and click Next.

      confirm-deployment

    5. In App Configurations, you can use the default configuration or customize the configuration by editing the YAML file. When you finish, click Deploy.

      set-app-configuration

    6. Wait until RadonDB PostgreSQL is up and running.

      RadonDB PostgreSQL-running

    Step 2: View PostgreSQL Cluster status

    1. On the Overview page of the project demo-project, you can see a list of resource usage in the current project.

      project-overview

    2. In Workloads under Application Workloads, click the StatefulSets tab and you can see the StatefulSet is up and running.

      statefulsets-running

      Click the StatefulSet to go to its detail page. You can see the metrics in line charts over a period of time under the Monitoring tab.

      statefulset-monitoring

    3. In Pods under Application Workloads, you can see all the Pods are up and running.

      pods-running

    4. In Volumes under Storage, you can see the PostgreSQL Cluster components are using persistent volumes.

      volumes

      Volume usage is also monitored. Click a volume item to go to its detail page. Here is an example of one of the data nodes.

      volume-status

    Step 3: Access RadonDB PostgreSQL

    1. Go to Pods under Application Workloads and click a Pod to go to its details page.

    2. On the Resource Status page, click the Terminal icon.

      RadonDB PostgreSQL-terminal

    3. In the displayed dialog box, run the following command and enter the user password in the terminal to use the app.

      psql -h <Pod name> -p 5432 -U postgres -d postgres

      Access RadonDB PostgreSQL

    4. If you want to access RadonDB PostgreSQL outside the cluster, see the open-source project of RadonDB PostgreSQL in detail.


    Thanks for the feedback. If you have a specific question about how to use KubeSphere, ask it on Slack. Open an issue in the GitHub repo if you want to report a problem or suggest an improvement.

    Previous : Deploy RadonDB MySQL on KubeSphere
    What’s on this Page