PostgreSQL: 3. Pick the instance size

This documentation is part of the GitHub Actions & GitLab CI guide. View the full guide here: Spin up a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and tear it down automatically.

👋 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 examples below use the entry-level instance 10G for PostgreSQL by default. This is a solid choice for most workloads, but you are welcome to adjust it as needed. To view all available instance types for PostgreSQL, you can 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
    Spin up a real PostgreSQL service from your GitHub Actions or GitLab CI pipeline, run your tests against it, and tear it down automatically
  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. ElephantSQL shutdown alternative
    Smoothly migrate from ElephantSQL: Stackhero offers a secure, dedicated PostgreSQL service.
  3. Automate with the CLI
    Start PostgreSQL, retrieve its credentials, and change its configuration programmatically with the Stackhero CLI