pgagroal manual · How-to · upstream 2.1.0
Configuration generator
From the upstream pgagroal manual, rendered in the Elevarq documentation style. Single-sourced from the pinned pgagroal release.
pgagroal-config is a utility tool that helps users generate and manage their pgagroal configuration files. It is particularly useful for new users to set up a base configuration or for automation scripts to modify existing settings safely.
Overview
The tool provides several commands to interact with the configuration:
- init: Interactive or automatic configuration generation.
- get: Retrieve a value from the configuration.
- set: Modify or add a value to the configuration.
- del: Remove a key or a section.
- ls: List sections or keys in a section.
Usage
Initializing a Configuration
The most common use case is generating a fresh configuration:
Command:
pgagroal-config init
This will guide you through the process of defining the listener address, ports, logging, and your first PostgreSQL server.
For automated setups, you can use the quiet mode:
Example:
pgagroal-config -q -o pgagroal.conf init
Modifying the Configuration
Instead of manually editing the ini file and potentially making syntax errors, you can use the set command:
Example:
pgagroal-config set pgagroal.conf pgagroal log_level debug
This command ensures that:
- The file is updated atomically.
- Comments and formatting other than the modified line are preserved.
- Permissions are set to
0600.
Troubleshooting
If you need to verify what keys are available in a section:
Example:
pgagroal-config ls pgagroal.conf pgagroal
Or to check a specific value:
Example:
pgagroal-config get pgagroal.conf pgagroal metrics
Security
pgagroal-config follows the same security principles as pgagroal:
- It refuses to run as
rootto prevent misconfiguration of system files. - It maintains strict file permissions (
0600) on all files it touches. - It uses
fsync()to ensure data integrity during writes.