PostgreSQL: 2. Find the PostgreSQL service store

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, and PgVector.
• 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!

Next, you will want to list the PostgreSQL service stores available to your account. The CLI accepts the store name (postgresql) directly, so there is no need to look up or copy any IDs.

# List PostgreSQL service stores (add --organization if you manage more than one)
stackhero services-store-list --name="postgresql"

You can use the store name postgresql in subsequent commands, or select a specific svs-xxxxxx ID from the list if you prefer.