[P1] Document-manager associations: run Postgres acceptance leg in CI

[stranske]

Why (verified evidence)

Post-merge verification (D4-verify-merged-2026-09-16T02) of #1678 (merge 25e497f834e10333b7f7f830bbe8c57c3ea7b974) against #1669 found junction-table logic and SQLite tests landed, but Postgres acceptance is opt-in only.

• Migration alembic/versions/022_document_managers.py, embeddings.py association inserts, and SQLite tests are present in squash diff.
• tests/test_document_managers_migration.py Postgres leg uses pytest.skip unless DOCUMENT_TEST_POSTGRES_URL is set — issue Preserve manager associations when document content is deduplicated #1669 acceptance requires disposable Postgres verification in CI, not skip-by-default.

Scope

Wire the existing Postgres service in .github/workflows/ci.yml to run document-manager association tests without manual env setup.

Tasks

• In .github/workflows/ci.yml, extend the postgres-integration job to export DOCUMENT_TEST_POSTGRES_URL from the existing MGRDB_PG_TEST_URL service and run pytest tests/test_document_managers_migration.py -k document_association -v.
• In tests/test_embeddings.py::test_shared_document_preserves_each_manager, ensure the shared-document regression still passes on SQLite and is included in the Gate pytest selection alongside tests/test_document_managers_migration.py.

Acceptance Criteria

• Named test: pytest tests/test_document_managers_migration.py -k document_association passes on Gate with Postgres available (no skip of postgres leg).
• Deliberate-break → revert: disable document_managers insert in embeddings.py → shared-document test FAILS on Postgres → restore → passes.

Non-Goals

• Do NOT remove SQLite coverage from fix(documents): preserve manager links across content deduplication #1678.
• No scaffolding / TODO-only changes.

Surfaced by D4-verify-merged-2026-09-16T02; verified against squash diff Manager-Database-1678.diff and issue #1669. Related: #1669, merged PR #1678.

[github-actions]

This issue is not yet agent-processable. See docs/AGENT_ISSUE_FORMAT.md.

• Tasks item must name a concrete file, symbol, path, config key, job, or command: Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI..

Advisory:

• 1 cited path(s) do not exist yet: 022_document_managers.py — expected when a task creates them; check for typos otherwise.

Recommended but absent: Scope, Implementation Notes

Dispatched the Agents Issue Optimizer format phase (attempt 1 of 3).

[agents-workflows-bot]

⚠️ Workflow failed

The agents-issue-optimizer workflow encountered an error.

Details: View workflow run

Format validation report:

This issue is **not yet agent-processable**. See `docs/AGENT_ISSUE_FORMAT.md`.

- `Tasks` item must name a concrete file, symbol, path, config key, job, or command: `Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI.`.

_Advisory:_
- 1 cited path(s) do not exist yet: `022_document_managers.py` — expected when a task creates them; check for typos otherwise.

[github-actions]

This issue is not yet agent-processable. See docs/AGENT_ISSUE_FORMAT.md.

• Tasks item must name a concrete file, symbol, path, config key, job, or command: Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI..

Advisory:

• 1 cited path(s) do not exist yet: 022_document_managers.py — expected when a task creates them; check for typos otherwise.

Recommended but absent: Scope, Implementation Notes

Dispatched the Agents Issue Optimizer format phase (attempt 2 of 3).

[agents-workflows-bot]

⚠️ Workflow failed

The agents-issue-optimizer workflow encountered an error.

Details: View workflow run

Format validation report:

This issue is **not yet agent-processable**. See `docs/AGENT_ISSUE_FORMAT.md`.

- `Tasks` item must name a concrete file, symbol, path, config key, job, or command: `Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI.`.

_Advisory:_
- 1 cited path(s) do not exist yet: `022_document_managers.py` — expected when a task creates them; check for typos otherwise.

[github-actions]

This issue is not yet agent-processable. See docs/AGENT_ISSUE_FORMAT.md.

• Tasks item must name a concrete file, symbol, path, config key, job, or command: Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI..

Advisory:

• 1 cited path(s) do not exist yet: 022_document_managers.py — expected when a task creates them; check for typos otherwise.

Recommended but absent: Scope, Implementation Notes

Dispatched the Agents Issue Optimizer format phase (attempt 3 of 3).

[github-actions]

Automated formatting stopped after 3 optimizer attempts. Fix the issue body manually, then remove agents:auto-pilot-pause before retrying.

[agents-workflows-bot]

⚠️ Workflow failed

The agents-issue-optimizer workflow encountered an error.

Details: View workflow run

Format validation report:

This issue is **not yet agent-processable**. See `docs/AGENT_ISSUE_FORMAT.md`.

- `Tasks` item must name a concrete file, symbol, path, config key, job, or command: `Ensure shared-document and search-dedup regressions execute on both SQLite and Postgres in CI.`.

_Advisory:_
- 1 cited path(s) do not exist yet: `022_document_managers.py` — expected when a task creates them; check for typos otherwise.