Chapter 5

Administration Manual

Administration of postgres clusters created with StackGres.

  • Installation

    Documentation how to install the StackGres operator.

  • Creating a Cluster

    Details about how to create a production StackGres cluster.

  • Connecting to the Cluster

    This page contains details about how to connect to a StackGres cluster.

  • Backups

    Details about how to set up and configure backups.

  • Configuration

    Details about default and custom configurations.

  • Managed SQL Scripts

    Details about how manage state and data using SQL scripts

  • Database Operations

    Run database maintenance operations on StackGres clusters using SGDbOps.

  • Postgres Extensions

    Details about how to set up and install Postgres extensions.

  • Monitoring

    Details about monitoring and metrics automatically stored on Prometheus.

  • High Availability

    Details about how Patroni is used to handle the database replicas and primary nodes.

  • Distributed Logs

    Details about how to create a distributed log instance.

  • Admin UI

    This page contains details about how to connect on the StackGres admin UI.

  • Replication

    This page contains details about how to create different cluster architecture topologies by using the replication features.

  • Sharded Cluster

    Overview of StackGres sharded cluster.

  • Upgrade

    Details how to use Helm to upgrade the operator.

  • CDC Streaming

    How to set up and manage Change Data Capture (CDC) streaming with SGStream.

  • Security

    Security best practices and configuration for StackGres clusters.

  • Babelfish Configuration

    How to configure and use Babelfish for PostgreSQL in StackGres.

  • Tuning

    How to configure your system and PostgreSQL in StackGres to improve performance.

  • Cluster rollout

    Details about the rollout of an SGCluster.

  • Uninstall

    Details about how to uninstall the operator and all its components.