Scope
This document focuses on how Astro Private Cloud configures Deployment metadata and result backend connections. It doesn’t cover infrastructure-level replication, backup, or recovery procedures. For complete setup steps, see the following documents:- Database architecture for database components, connection pooling, high availability, and production recommendations.
- Access Airflow database for connecting to the database, running queries, and backup and restore procedures.
- Bring your own Airflow database for manual metadata and result backend connections.
- Configure Kerberos authentication for Airflow databases for Kerberos-specific database setup.
- Programmatically create or update Deployments on Astro Private Cloud for upsert workflow details.
Default deployment database behavior
By default, Astro Private Cloud generates deployment-specific database connection details from:- Global deployment configuration.
- Deployment release name.
- Cluster database type.
- One deployment database name derived from release name.
airflowschema for metadata.celeryschema for result backend.- Separate generated credentials for metadata and result backend access.
Configure provisioning behavior
Set global database behavior in deployment config:enabled: falseskips automatic generation of deployment connection details.retainOnDelete: truekeeps deployment database resources after deployment deletion.allowRootAccess: trueleaves root grants in place.
Manual connection input
Manual connection strings are disabled by default. To pass manual connection values in upsert payloads, setdeployments.databaseManagement.manualConnectionStrings.enabled to true. In APC 2.x this is a deployments.* setting, so cluster, Workspace, and Deployment overrides take precedence over values.yaml. The recommended path is to add the following to the data plane cluster’s Configuration Override (cluster overrides apply to deployments.*, so don’t include the deployments. prefix):
PgBouncer input behavior
PgBouncer behavior applies through deployment chart config:- URI-style manual connection input is rejected.
- JSON-style manual connection input is required.
metadataConnectionJsonresultBackendConnectionJson
Kerberos validation behavior
WhenkerberosEnabled is true in an upsert payload:
- Provide both metadata and result backend connections, either URI pair or JSON pair.
- Provide
pgbouncerConfig. - Set
pgbouncerConfig.extraIniMetadatawithuser=. - Set
pgbouncerConfig.extraIniResultBackendwithuser=. - Set
pgbouncerConfig.sslmode. - Set
pgbouncerConfig.extraIniwith:server_gssauth_negotiate = allowserver_krb_spn