database · inferred from evidence
Postgres
A relational database management system.
- Meltano with Airflow fails: sqlite database file doesn't exist, do you need to create the database with airflow db init
How to fix: Meltano with Airflow fails: sqlite database file doesn't exist, do you need to create the database with airflow db init. The verified fix from the maintainer thread, distilled into reusable steps.
- Unable to update Elasticsearch mapping: elastic: Error 403 on Create Custom Attributes
What this covers: Self-hosted Temporal 1.20.4 with AWS OpenSearch 2.5 and RDS Postgres. The fix that worked: The cluster was in dual visibility mode: both visibilityStore (pointing at Postgres) and advancedVisibilityStore (pointing at OpenS
- Logto fails to start: self signed certificate in certificate chain (managed Postgres)
What this covers: Starting the Logto container against a DigitalOcean Managed Postgres database failed during initialization with Error: self signed certificate in certificate chain. The fix that worked: Point Node at DigitalOcean's CA cert
- Langfuse docker compose fails on ARM: wrong-arch migrate binary, syntax error on ClickHouse migrations
What this covers: Self-hosting Langfuse v3 via docker compose on an ARM64 Linux machine: the langfuse-web container crash-loops on ClickHouse migrations with `/usr/bin/migrate: line 1: syntax error: unexpected ")"` and `Applying clickhouse
- Flipt 1.9.0 Postgres dial tcp lookup postgres device or resource busy
This was a Flipt regression fixed in v1.9.1 and v1.10.1, upgrade to either of those patch releases and the Postgres connection works again. The reporter confirmed v1.9.1 fixed it in both local Rancher Desktop and GCP clusters.
- fly ssh console -C drops environment variables (e.g. PGPASSWORD)
fly ssh console -C mangled env var assignments in the command because of a hallpass bug on Fly side. Pick up the updated hallpass with fly deploy or fly machine update and it works.
- Airbyte MongoDB incremental sync fails repeatedly with "Saved offset is not valid"
Airbyte MongoDB incremental sync fails repeatedly with "Saved offset is not valid". The connector had a bug where it didn't update the saved offset properly, so every incremental sync after the first choked on a stale offset and fell back t
- Fix Streamlit state wiped or duplicated: session_state vs reruns, cache_data vs cache_resource, widget-key collisions
Diagnoses and fixes the most common Streamlit state bugs: counters and values lost because every interaction reruns the whole script; choosing st.cache_data (serialized copy per call) vs st.cache_resource (one shared singleton); mutating ca