📌 Purpose & Quick Summary

For enterprise applications requiring advanced object-relational capabilities, GIS geospatial data, or complex transactions, BoostonCP provides dedicated PostgreSQL Databases support. From this interface, you can provision PostgreSQL schemas, configure database users, obtain direct connection URI strings, and integrate Python, Node.js, Ruby, or Go applications.

BoostonCP PostgreSQL Databases Overview

Figure 10: PostgreSQL database hub showing active databases, port 5432 listener, and connection URIs.

🖥️ Interface Tour & Elements

  1. PostgreSQL Engine Status: Real-time service indicator confirming PostgreSQL daemon availability on Port 5432.
  2. Create Database Action Button: Launches the PostgreSQL database creation modal.
  3. Database Ledger Table: Displays Database Name, Assigned User, Connection Host, Port 5432, and Action controls.
  4. Copy Connection String Button: 1-click utility that copies the complete application connection URI formatted for .env or application configuration.

🛠️ Step-by-Step Instructions

Step 1: Provisioning a PostgreSQL Database

  1. In the sidebar, click PostgreSQL DBs (icon: fa-server).
  2. Click Create PostgreSQL Database.
  3. In the dialog:
    • Database Name: Enter the database suffix (e.g. app).
    • Username: Enter the database username.
    • Password: Generate or input a strong password.
  4. Click Create Database. The PostgreSQL engine provisions the database and assigns owner privileges.

Step 2: Copying the Connection URI

  1. In the database ledger table, locate your database.
  2. Click the Copy URI button.
  3. The connection string is formatted as: postgresql://username:[email protected]:5432/dbname
  4. Paste this string directly into your Django, Prisma, or Rails DATABASE_URL environment variable.

Step 3: Deleting a PostgreSQL Database

  1. Click the Delete button next to the database entry.
  2. Confirm the prompt to immediately terminate connections and drop the database.

⚙️ Complete Field & Parameter Reference Table

Connection Parameter Value Description
Host 127.0.0.1 Local loopback address ensuring fast, secure local socket communication.
Port 5432 Standard PostgreSQL listener port.
Protocol postgresql:// Standard URI scheme for modern ORMs (Prisma, TypeORM, SQLAlchemy).
Default Encoding UTF8 Universal character encoding standard.

❓ Troubleshooting & Common Errors

1. Card Displays "PostgreSQL Not Installed"

  • Cause: The PostgreSQL service has not been installed by the server administrator on this BoostonCP node.
  • Solution: Contact your hosting provider or server administrator to install the PostgreSQL package from the Admin Software Store.