PostgreSQL: 5. Retrieve credentials

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.

The service-configuration-get command returns the complete configuration for your service, including auto-generated passwords and connection details. The output is in JSON format, making it easy to use in scripts and automation.

stackhero service-configuration-get --service=svc-xxxxxx --format=json

Continue reading this guide

  1. Read the full guide: Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and change its configuration programmatically with the Stackhero CLI
  2. 1. Authenticate
  3. 2. Find the PostgreSQL service store
  4. 3. Pick an instance size and a region
  5. 4. Create the service
  6. 6. Change the configuration

Other articles for PostgreSQL

  1. Getting started
    How to get started with PostgreSQL
  2. ElephantSQL shutdown alternative
    Smoothly migrate from ElephantSQL: Stackhero offers a secure, dedicated PostgreSQL service.
  3. GitHub Actions & GitLab CI
    Spin up a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and tear it down automatically