PostgreSQL
Deploy and connect to PostgreSQL databases in Sealos DevBox
PostgreSQL is a powerful, open-source object-relational database system. In Sealos DevBox, you can easily set up and connect to PostgreSQL databases for your development projects.
Deploy PostgreSQL in Sealos
Sealos makes it easy to deploy a PostgreSQL database with just a few clicks. follow these steps:
From the Sealos desktop, click on the "Database" icon to open the Database app.
Click on the "Create New Database" button. In the deployment form:
- Select "Postgres" as the database type.
- Choose the desired PostgreSQL version (e.g., postgresql-14.8.0).
- Enter a name for your database (use lowercase letters and numbers only).
- Adjust the CPU and Memory sliders to set the resources for your database.
- Set the number of replicas (1 for single-node development and testing).
- Specify the storage size (e.g., 3 Gi).
Review the projected cost on the left sidebar. Click the "Deploy" button in the top right corner to create your PostgreSQL database.
Once deployed, Sealos will provide you with the necessary connection details.
Connect to PostgreSQL in DevBox
Here are examples of how to connect to your PostgreSQL database using different programming languages and frameworks within your DevBox environment: