PostgreSQL: 4. Create the service
This documentation is part of the Automate with the CLI guide. You can view the complete guide here: Start PostgreSQL, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI.
👋 Welcome to the Stackhero documentation!
Stackhero offers a fully managed PostgreSQL cloud solution, designed for reliability and performance:
- Unlimited connections and data transfers for effortless scalability.
- PgAdmin web interface included for straightforward database management.
- A wide range of popular extensions included, such as
PostGIS,TimescaleDB, andPgVector.- Simple, one-click updates to keep your database secure and up to date.
- Optimal performance and enhanced security on private, dedicated infrastructure.
Save time and make your life easier: it takes just 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!
Below is an example script that creates a stack, adds your PostgreSQL service to it, waits for it to start, retrieves its configuration (including generated credentials), and then applies a new configuration.
#!/bin/bash
set -e
export STACKHERO_TOKEN="usr-xxxxxx:your-token"
serviceStore="postgresql" # The PostgreSQL service store name (see step 2)
instance="..." # An instance size from step 3
region="europe" # A region name from step 3
# Create a stack for your service (uses your default organisation; add --organization if needed)
stackId=$(stackhero --format=script stack-create \
--name="My PostgreSQL stack")
echo "Stack created: ${stackId}"
# Add PostgreSQL to the stack (names are resolved automatically)
serviceId=$(stackhero --format=script service-add \
--stack="My PostgreSQL stack" \
--service-store="${serviceStore}" \
--instance="${instance}" \
--region="${region}")
echo "Service added: postgresql"
# Wait for the service to be fully operational (this may take a few minutes)
stackhero service-wait-for --service="postgresql"
# Retrieve the service configuration, including generated credentials
stackhero service-configuration-get --service="postgresql" --format=json