This content originally appeared on DEV Community and was authored by Aravin
This is Part 3 of the BigAnimal in PostgreSQL series.
👉 Previous: How to Configure BigAnimal
1. To View Cluster details
biganimal cluster show
Purpose:
Displays detailed information about all clusters or a specific cluster running in your EDB BigAnimal environment.
- Lists all PostgreSQL clusters you have access to under your BigAnimal account.
- Shows summary details like:
- Cluster ID
- Name
- Status (e.g., Running, Provisioning, Stopped)
- PostgreSQL version
- Region / Cloud provider
- High Availability mode (Single, HA, DR)
- Node size / instance type
- Number of nodes
- VPC or Network details
- Creation time
ID NAME STATUS VERSION REGION HA MODE
p-1234567890 prod-db running 15.4 aws/us-east-1 HA
p-0987654321 staging-db stopped 16.2 azure/eastus Single
You can also add flags such as:
biganimal cluster show --id p-1234567890
to view only one cluster’s details.
2. Displays connection details for a specific PostgreSQL cluster
biganimal cluster show-connection --id p-23456789
- The --id option specifies which cluster you want connection details for.
- The command shows:
- Primary endpoint (hostname or IP)
- Read-only endpoint (for replicas)
- Port number
- Database name
- Usernames (like postgres or biganimal_user)
- Connection string (URI format) — both psql and pgAdmin compatible
- SSL mode and certificate details
- Load balancer endpoint (if HA enabled)
Cluster ID: p-23456789
Cluster Name: prod-db
Connection Details:
Hostname: hostname
Port: 5432
Database: arcflow
User: user_name
SSL Mode: require
Connection String:
psql "host=hostname/ip port=5432 dbname=arcflow user=user_name sslmode=require"
This content originally appeared on DEV Community and was authored by Aravin
Aravin | Sciencx (2025-10-07T09:26:49+00:00) View Cluster Details. Retrieved from https://www.scien.cx/2025/10/07/view-cluster-details/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.