PostgreSQL: 5. Retrieve credentials

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 easy database management.
  • Popular extensions included, such as PostGIS, TimescaleDB, and PgVector.
  • Simple, one-click updates to keep your database secure and up to date.
  • High performance and enhanced security on private, dedicated infrastructure.

Save time and make your life easier: it only takes 5 minutes to try Stackhero's PostgreSQL cloud hosting solution!

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 modify its configuration programmatically using the Stackhero CLI
  2. 1. Authenticate
  3. 2. Find the PostgreSQL service store
  4. 3. Choose 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. Alternative to ElephantSQL Shutdown
    Smoothly migrate from ElephantSQL: Stackhero offers a secure, dedicated PostgreSQL service.
  3. GitHub Actions & GitLab CI
    Launch a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and automatically tear it down