PostgreSQL
PostgreSQL provides a relational database with branch selection in the catalog. Installing a new branch does not automatically transfer data from an existing server.
Available versions
16, 17 and 18. Select a major branch; the exact patch version is resolved from available packages. Installation may require allowing the PostgreSQL repository.
These options come from the application installation catalog. A catalog entry alone does not guarantee package availability on every server; verify the exact installed version in the service inventory.
Install and prepare
- Select PostgreSQL and the required branch in services or a PostgreSQL profile.
- Allow the required repository if requested.
- Follow output and verify the specific branch is running.
- Prepare the application database and role, then test connectivity.
Configuration
For the selected branch, the editor exposes postgresql.conf and pg_hba.conf under /etc/postgresql/VERSION/main/. The first configures the server; the second controls authentication. The installed branch replaces VERSION.
The catalog uses port 5432; multiple branches may need different ports. Verify which instance the application actually connects to.
Application and maintenance
Configure host, port, database, role and password according to project requirements. The project environment must also be passed to the command or process that uses it.
For authentication changes, check both the password and the matching pg_hba.conf rule. Prepare an export and verified recovery before changing branches. Restarting interrupts connected applications.