PostgreSQL Databases: Creation, Role Management & Connection Strings

PostgreSQL Databases • Main Management Table • Native 1920x1080 View

📌 Purpose & Quick Summary

Use the PostgreSQL DBs page to manage enterprise object-relational PostgreSQL databases (Port 5432). Ideal for Django, Ruby on Rails, Node.js Prisma, and complex enterprise analytics applications.

🛠️ Step-by-Step Instructions: Creating a PostgreSQL Database

1. Navigate to Databases > PostgreSQL DBs in the sidebar.
2. Click Create PostgreSQL DB.
3. In the form:
   • Database Name: Enter name (e.g., app_postgres).
   • Username / Role: Enter role name.
   • Password: Set password.
4. Click Create Database. BoostonCP creates the database and grants owner privileges.
5. Connection String Format: postgresql://username:[email protected]:5432/databasename