PostgreSQL: 3. Choose the instance size

This documentation is part of the GitHub Actions & GitLab CI guide. You can view the complete guide here: Launch a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and automatically tear it down.

👋 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 examples below use the entry-level instance 10G for PostgreSQL by default. This is a reliable choice for most workloads, but you can adjust it as needed. To see all available instance types for PostgreSQL, run:

# The NAME column shows the value to pass to --instance
stackhero instances-store-list --service-store=postgresql

Continue reading this guide

  1. Read the full guide: 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
  2. 1. Create an access token and store it as a CI secret
  3. 2. The lifecycle script
  4. 4. GitHub Actions
  5. 5. GitLab CI

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. Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and modify its configuration programmatically using the Stackhero CLI