Skip to main content

PostgreSQL Connection

Select PostgreSQL for a PostgreSQL endpoint. The current setup form uses the common host, database, credential, provider-parameter, pooling and transaction fields; it has no PostgreSQL-only option panel.

SettingDefaultGuidance
Server NameEmptyReviewed PostgreSQL host or endpoint.
Database NameEmptyDatabase selected for the connection.
User Name / PasswordEmptyLeast-privilege runtime identity. The saved DB password is encrypted but must still be protected.
Other parametersEmptyProvider-specific values, including any approved port or TLS options required by the deployed component. Do not copy unreviewed connection strings.
Disconnect after useClearedCloses after use when enabled.
Persistent connectionClearedEnables persistent/pool behaviour; minimum and maximum connections default to 0.
Maximum transactions per update0Shared limit field. Leave at the default unless the Flow/database design provides a tested value.
Disable transactionsClearedRemoves Velox's normal transaction handling when enabled.
Read / write isolationRead CommittedUI choices are Read Committed, Repeatable Read and Read Uncommitted. PostgreSQL/provider interpretation must be verified rather than assumed from the label.

The setup form hides SQL Server-specific authentication/driver/trust fields, the MySQL version field, and ADO/ODBC alias/provider fields.

After Test succeeds, verify the exact schemas, case-sensitive identifiers, query parameters, data types and writes through a DB Definition. Run that test from the actual Velox service host and identity. Record any required provider parameters in operational configuration notes, then use Check Usage before changing them.