Deploy PostgreSQL on KubeSphere
PostgreSQL is a powerful, open-source object-relational database system, which is famous for reliability, feature robustness, and performance.
This tutorial walks you through an example of how to deploy 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 theoperator
role. In this tutorial, you log in asproject-regular
and work in the projectdemo-project
in the workspacedemo-workspace
. For more information, see Create Workspaces, Projects, Users and Roles.
Hands-on Lab
Step 1: Deploy PostgreSQL from the App Store
On the Overview page of the project
demo-project
, click App Store in the upper-left corner.Find PostgreSQL and click Install on the App Information page.
Set a name and select an app version. Make sure PostgreSQL is deployed in
demo-project
and click Next.In App Settings, specify persistent volumes for the app and record the username and the password, which will be used later to access the app. When you finish, click Install.
Note
To specify more values for PostgreSQL, use the toggle switch to see the app's manifest in YAML format and edit its configurations.Wait until PostgreSQL is up and running.
Step 2: Access the PostgreSQL database
To access PostgreSQL outside the cluster, you need to expose the app through a NodePort first.
Go to Services and click the service name of PostgreSQL.
Click More and select Edit External Access from the drop-down list.
Select NodePort for Access Method and click OK. For more information, see Project Gateway.
Under Ports, you can see the port is exposed, which will be used in the next step to access the PostgreSQL database.
Expand the Pod menu under Pods and click the Terminal icon. In the pop-up window, enter commands directly to access the database.
Note
You can also use a third-party application such as SQLPro Studio to connect to the database. You may need to open the port in your security groups and configure related port forwarding rules depending on where your Kubernetes cluster is deployed.For more information, see the official documentation of PostgreSQL.
Feedback
Was this page Helpful?
Receive the latest news, articles and updates from KubeSphere
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.