PostgreSQL: 2. Find the PostgreSQL service store

This documentation is part of the Automate with the CLI guide. View the full guide here: Start PostgreSQL, retrieve its credentials, and change its configuration programmatically with the Stackhero CLI.

👋 Welcome to the Stackhero documentation!

Stackhero provides a fully managed PostgreSQL cloud service, designed for reliability and speed:

• Unlimited connections and data transfers for seamless scaling.
• PgAdmin web UI included for intuitive database management.
• Popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
• Simple, one-click updates keep your database secure and current.
• High performance and strong security on private, dedicated infrastructure.

You can get started with Stackhero's PostgreSQL cloud hosting in just a few minutes. Enjoy a reliable database experience and save valuable time managing your data.

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 refer to the store name postgresql in subsequent commands, or choose a specific svs-xxxxxx ID from the list if you prefer.