Postgres connection help
Use this page after reading Set up Orloi. The recommended destination is a Postgres database dedicated to Orloi. It can live in your existing provider account or infrastructure project; you do not need separate provider infrastructure. Reusing an existing database may work, but it is an intentional exception rather than the default setup path. Save the connection through the setup screen, then confirm the first in-scope Airtable change in Activity.
This page covers the normal setup decision. For provider networking, TLS limits, connection ownership, schema upgrades, database moves, and destructive database operations, use the Advanced technical reference.
Before submitting a connection
- Use the provider's standard TCP connection string for the intended database, not a dashboard URL, HTTP database API, or secret-manager reference.
- Confirm that the destination, backup policy, and recovery owner are appropriate for the history Orloi will store.
- Save the exact connection that Orloi will test and use. Do not assume that a connection tested from a laptop or with a different administrator credential proves the saved connection will work.
- Keep database credentials out of tickets, prompts, screenshots, and source control.
After setup succeeds, make one small, reversible change in an included Airtable field and use Activity. A successful connection proves that the destination can be reached and prepared; it does not by itself prove that new activity or derived views are current.
Troubleshooting by symptom
| Symptom | Next step |
|---|---|
“Use a postgresql:// URL” | Submit the provider's standard TCP URL. Check Advanced provider connectivity for unsupported URL forms. |
| “Database not reachable” | Confirm the provider endpoint and approved network path Orloi can use. The Advanced networking guidance covers provider-specific reachability limits. |
| “Authentication failed” | Re-copy the intended user, password, host, port, and database name. Rotate a leaked password rather than pasting it into a ticket or prompt. |
| “Cannot create schemas” or “must be owner” | Review the saved connection's object-ownership and upgrade requirements in the Advanced schema-upgrade guidance. |
| Airtable authorization or base access fails | Reconnect an authorization that can read the selected base, tables, and fields; see Set up Orloi. |
| Setup succeeds but nothing appears | Make a new in-scope Airtable change, then check Activity. Confirm the base is active and the changed field is in scope; use Data lineage and freshness for the operator checks. |
| Capture later becomes stale or reports lag | Check the provider's availability and the dashboard's connection status before relying on the newest results. Use Data lineage and freshness for freshness stages and the Advanced technical reference for storage and upgrade boundaries. |
Orloi does not manage provider backups, historical database moves, or customer-controlled data deletion. See Database moves and destructive operations for those Advanced boundaries.