ci: connect to postgres via service hostname for Gitea Actions

Gitea Actions runs jobs inside a container, so a service container is reachable by its service name (postgres), not localhost; localhost:5432 yields connection refused. Also drop the unnecessary 5432:5432 host port mapping that caused 'port already allocated' collisions. Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>
M4: ingestion management (#1 )
2026-06-19 08:54:18 +00:00 · 2026-06-08 17:40:26 +08:00
1 changed files with 2 additions and 6 deletions
@@ -19,13 +19,11 @@ jobs:
          POSTGRES_USER: opengoods
          POSTGRES_PASSWORD: opengoods
          POSTGRES_DB: opengoods
-        ports:
-          - "5432:5432"
        options: >-
          --health-cmd "pg_isready -U opengoods"
          --health-interval 5s --health-timeout 5s --health-retries 10
    env:
-      OPENGOODS_DATABASE_URL: postgres://opengoods:opengoods@localhost:5432/opengoods?sslmode=disable
+      OPENGOODS_DATABASE_URL: postgres://opengoods:opengoods@postgres:5432/opengoods?sslmode=disable
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-go@v5
@@ -73,13 +71,11 @@ jobs:
          POSTGRES_USER: opengoods
          POSTGRES_PASSWORD: opengoods
          POSTGRES_DB: opengoods
-        ports:
-          - "5432:5432"
        options: >-
          --health-cmd "pg_isready -U opengoods"
          --health-interval 5s --health-timeout 5s --health-retries 10
    env:
-      DBURL: postgres://opengoods:opengoods@localhost:5432/opengoods?sslmode=disable
+      DBURL: postgres://opengoods:opengoods@postgres:5432/opengoods?sslmode=disable
    steps:
      - uses: actions/checkout@v4
      - uses: actions/setup-go@v5
Author	SHA1	Message	Date
rosemariejebbjtxbfp	19b7c43f37	ci: connect to postgres via service hostname for Gitea Actions CI / Go (api) (pull_request) Successful in 30s Details CI / Python (ingestion) (pull_request) Successful in 7s Details CI / Migrations (postgres) (pull_request) Successful in 16s Details Gitea Actions runs jobs inside a container, so a service container is reachable by its service name (postgres), not localhost; localhost:5432 yields connection refused. Also drop the unnecessary 5432:5432 host port mapping that caused 'port already allocated' collisions. Co-Authored-By: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>	2026-06-19 08:54:18 +00:00
lixu	57537c880d	M4: ingestion management (#1 ) CI / Go (api) (push) Failing after 14s Details CI / Migrations (postgres) (push) Failing after 33s Details CI / Python (ingestion) (push) Failing after 13m10s Details Incremental OFF + GS1 supplement + dedup/conflict + quality scoring + scheduler	2026-06-08 17:40:26 +08:00