Docker-compose issues when building a project

[SlavaLenskyy]

I'm not 100% sure this is not related to my local env, but I've tried on two different machines so far with the same result. I also don't see any errors while docker-compose is running.

After running

git clone https://github.com/cybertec-postgresql/pgwatch.git && cd pgwatch

docker compose -f ./docker/docker-compose.yml up --detach

all the instances are up and running I see several issues:

1. Grafana admin login/password ( admin/pgwatch2admin ) doesn't work.
2. pgwatch has 75 metrics present, but metrics.yaml defines 77 metrics. Missing last two metrics: postgres_role, archiver_pending_count.
3. Because postgres_role metric is missing, grafana doesn't display a list of databases in dropdown menu in dashboards.

[SlavaLenskyy]

also adding metrics yields error:

[SlavaLenskyy]

skoffer@laptop-np2:~/git/pgwatch$ docker compose -f ./docker/docker-compose.yml up --detach
[+] Running 32/32
 ✔ pgpool Pulled                                                                                                                                                                                        11.8s
   ✔ 41124b034b30 Pull complete                                                                                                                                                                         10.6s
 ✔ pgwatch Pulled                                                                                                                                                                                       13.2s
   ✔ 9824c27679d3 Pull complete                                                                                                                                                                         10.2s
   ✔ eefea6486fab Pull complete                                                                                                                                                                         11.9s
   ✔ e643b863bf0f Pull complete                                                                                                                                                                         12.0s
 ! postgres Warning         pull access denied for postgres-plpython3u, repository does not exist or may require 'docker login': denied: requested access to the resource is denied                      0.8s
 ✔ grafana Pulled                                                                                                                                                                                       19.4s
   ✔ f18232174bc9 Pull complete                                                                                                                                                                          6.4s
   ✔ f29524dcb621 Pull complete                                                                                                                                                                          7.0s
   ✔ 5d91856773d5 Pull complete                                                                                                                                                                          7.7s
   ✔ 80fa3fbe3c15 Pull complete                                                                                                                                                                          7.8s
   ✔ 20d3cfd99f6f Pull complete                                                                                                                                                                          7.9s
   ✔ d919b3851dd3 Pull complete                                                                                                                                                                          7.9s
   ✔ b13b23f8a52e Pull complete                                                                                                                                                                         14.9s
   ✔ 1b0a5b3afefb Pull complete                                                                                                                                                                         18.2s
   ✔ ff772a259fcb Pull complete                                                                                                                                                                         18.2s
   ✔ 7d29191c2f0b Pull complete                                                                                                                                                                         18.3s
 ✔ pgbouncer Pulled                                                                                                                                                                                     11.8s
   ✔ c6c231d60498 Pull complete                                                                                                                                                                         10.6s
 ✔ prometheus Pulled                                                                                                                                                                                     6.3s
   ✔ 9fa9226be034 Pull complete                                                                                                                                                                          0.4s
   ✔ 1617e25568b2 Pull complete                                                                                                                                                                          0.8s
   ✔ 097a69c6efe6 Pull complete                                                                                                                                                                          3.1s
   ✔ 2ee6cb77bebd Pull complete                                                                                                                                                                          5.0s
   ✔ a4e782810d03 Pull complete                                                                                                                                                                          5.0s
   ✔ 76619c1908eb Pull complete                                                                                                                                                                          5.1s
   ✔ 2dfc70ad9941 Pull complete                                                                                                                                                                          5.1s
   ✔ fd1d3a5a5f79 Pull complete                                                                                                                                                                          5.1s
   ✔ 5e4c02bc6754 Pull complete                                                                                                                                                                          5.1s
   ✔ 208063e2dcbb Pull complete                                                                                                                                                                          5.2s
 ✘ postgres-standby Error   pull access denied for postgres-plpython3u, repository does not exist or may require 'docker login': denied: requested access to the resource is ...                         0.8s
[+] Building 20.3s (10/10) FINISHED
 => [internal] load local bake definitions                                                                                                                                                               0.0s
 => => reading from stdin 678B                                                                                                                                                                           0.0s
 => [internal] load build definition from Dockerfile.postgres-plpython3u                                                                                                                                 0.0s
 => => transferring dockerfile: 316B                                                                                                                                                                     0.0s
 => [internal] load metadata for docker.io/library/postgres:17                                                                                                                                           1.1s
 => [auth] library/postgres:pull token for registry-1.docker.io                                                                                                                                          0.0s
 => [internal] load .dockerignore                                                                                                                                                                        0.0s
 => => transferring context: 2B                                                                                                                                                                          0.0s
 => [1/3] FROM docker.io/library/postgres:17@sha256:4d89c904835259bc58876520e56267ca07a4ebd6a027f7814bbbf91b50d685be                                                                                     8.3s
 => => resolve docker.io/library/postgres:17@sha256:4d89c904835259bc58876520e56267ca07a4ebd6a027f7814bbbf91b50d685be                                                                                     0.0s
 => => sha256:8663c6099632b20b61322e6f9a0a6aa4034ed061bfec05949566f352b92dc5fa 9.89kB / 9.89kB                                                                                                           0.0s
 => => sha256:175211425b3c49fa4239b046bed694b1593b195602632a69b0195f01578683fc 3.63kB / 3.63kB                                                                                                           0.0s
 => => sha256:c2922dd5c76b2cfc635954cb81e0bbc78ffca09ab9c5ab798a121af686a1a5c8 1.17kB / 1.17kB                                                                                                           0.2s
 => => sha256:28b0f0abf5b38c6668547cf19930a55066078f04dbe8176ce6bf0f5e30fe7733 4.53MB / 4.53MB                                                                                                           1.0s
 => => sha256:4d89c904835259bc58876520e56267ca07a4ebd6a027f7814bbbf91b50d685be 10.26kB / 10.26kB                                                                                                         0.0s
 => => sha256:59e22667830bf04fb35e15ed9c70023e9d121719bb87f0db7f3159ee7c7e0b8d 28.23MB / 28.23MB                                                                                                         1.6s
 => => sha256:a623957f847ddb0aa95630198bd190581fb0e8ea0cdd13385049e6a6d22ef3ae 1.45MB / 1.45MB                                                                                                           1.1s
 => => sha256:bfabbcdba989f58a356647ddce45799bc036b34233d46419cd2eba535b27844d 8.07MB / 8.07MB                                                                                                           1.5s
 => => sha256:0e5bba37029ae0f0701011471048b4f02a55aa1d0d7be5d381c478e78f9c8082 1.20MB / 1.20MB                                                                                                           1.5s
 => => sha256:1ed9ff0b516006d103ace7c76c84d925160a9378afae3b5e04b3a571dcba4638 116B / 116B                                                                                                               1.6s
 => => sha256:06b2fd76987c4b93855882138ea092bf99704eae0425998682715eeaa26f974a 3.14kB / 3.14kB                                                                                                           1.7s
 => => extracting sha256:59e22667830bf04fb35e15ed9c70023e9d121719bb87f0db7f3159ee7c7e0b8d                                                                                                                1.4s
 => => sha256:4a43c57a903dde6cf5d9fde8771b830c151195385e9e9160cd34dfc7c43b522d 10.23kB / 10.23kB                                                                                                         1.8s
 => => sha256:9e482b60495e7eb58a22e420723fa23796f7b56243e14e2e6e3d4fb3614d8239 112.80MB / 112.80MB                                                                                                       5.3s
 => => sha256:dcce1c0b58a8ad17ab684afeb63295541228ec80681307f5dbe6d8350a01be48 129B / 129B                                                                                                               1.9s
 => => sha256:38072b29d55e01d8942b05f7ddd26fe2bdedc4865a7b0f9ccb3078e628ff1d9c 167B / 167B                                                                                                               2.3s
 => => sha256:d98e5494f24026ae4766bca5b348aa55aa309a9edeb1e8e4ed6263d8d3ca524c 5.93kB / 5.93kB                                                                                                           2.1s
 => => sha256:017403a0b5e1a47f9ff958f129afd947cf7f31ec501d1257cb1d8f2c9d3cb46c 185B / 185B                                                                                                               2.4s
 => => extracting sha256:c2922dd5c76b2cfc635954cb81e0bbc78ffca09ab9c5ab798a121af686a1a5c8                                                                                                                0.0s
 => => extracting sha256:28b0f0abf5b38c6668547cf19930a55066078f04dbe8176ce6bf0f5e30fe7733                                                                                                                0.1s
 => => extracting sha256:a623957f847ddb0aa95630198bd190581fb0e8ea0cdd13385049e6a6d22ef3ae                                                                                                                0.0s
 => => extracting sha256:bfabbcdba989f58a356647ddce45799bc036b34233d46419cd2eba535b27844d                                                                                                                0.4s
 => => extracting sha256:0e5bba37029ae0f0701011471048b4f02a55aa1d0d7be5d381c478e78f9c8082                                                                                                                0.0s
 => => extracting sha256:1ed9ff0b516006d103ace7c76c84d925160a9378afae3b5e04b3a571dcba4638                                                                                                                0.0s
 => => extracting sha256:06b2fd76987c4b93855882138ea092bf99704eae0425998682715eeaa26f974a                                                                                                                0.0s
 => => extracting sha256:9e482b60495e7eb58a22e420723fa23796f7b56243e14e2e6e3d4fb3614d8239                                                                                                                2.2s
 => => extracting sha256:4a43c57a903dde6cf5d9fde8771b830c151195385e9e9160cd34dfc7c43b522d                                                                                                                0.0s
 => => extracting sha256:dcce1c0b58a8ad17ab684afeb63295541228ec80681307f5dbe6d8350a01be48                                                                                                                0.0s
 => => extracting sha256:38072b29d55e01d8942b05f7ddd26fe2bdedc4865a7b0f9ccb3078e628ff1d9c                                                                                                                0.0s
 => => extracting sha256:d98e5494f24026ae4766bca5b348aa55aa309a9edeb1e8e4ed6263d8d3ca524c                                                                                                                0.0s
 => => extracting sha256:017403a0b5e1a47f9ff958f129afd947cf7f31ec501d1257cb1d8f2c9d3cb46c                                                                                                                0.0s
 => [2/3] RUN apt-get update && apt-get install -y     postgresql-plpython3-17 postgresql-17-pg-qualstats python3-psutil     pg-activity                                                                 9.9s
 => [3/3] RUN apt-get clean && rm -rf /var/lib/apt/lists/*                                                                                                                                               0.4s
 => exporting to image                                                                                                                                                                                   0.3s
 => => exporting layers                                                                                                                                                                                  0.3s
 => => writing image sha256:63c3768fa40e86fb6f7f267df851ee278320c20a29db1c5012347ac4e1271b00                                                                                                             0.0s
 => => naming to docker.io/library/postgres-plpython3u:latest                                                                                                                                            0.0s
 => resolving provenance for metadata file                                                                                                                                                               0.0s
[+] Running 9/9
 ✔ postgres                    Built                                                                                                                                                                     0.0s
 ✔ Network docker_default      Created                                                                                                                                                                   0.0s
 ✔ Container postgres          Healthy                                                                                                                                                                  11.1s
 ✔ Container pgwatch           Started                                                                                                                                                                  11.6s
 ✔ Container postgres-standby  Started                                                                                                                                                                  11.4s
 ✔ Container pgpool            Started                                                                                                                                                                  11.4s
 ✔ Container pgbouncer         Started                                                                                                                                                                  11.7s
 ✔ Container grafana           Started                                                                                                                                                                  11.6s
 ✔ Container prometheus        Started  

[SlavaLenskyy]

[SlavaLenskyy]

[pashagolub]

1. Grafana admin login/password ( admin/pgwatch2admin ) doesn't work.

admin/admin are defaults for new Grafana. But I think you don't need it anyway since the Grafana is started with GF_AUTH_ANONYMOUS_ORG_ROLE: Admin, meaning you should have admin role immediately without login

[pashagolub]

2. pgwatch has 75 metrics present, but metrics.yaml defines 77 metrics. Missing last two metrics: postgres_role, archiver_pending_count.

You pulled pgwatch image but you use master from github.

You need to rebuild pgwatch image

docker compose -f ./docker/docker-compose.yml up build

or checkout official release tag

git checkout v3.7.0

[pashagolub]

also adding metrics yields error:

You have a syntax error. It should be

11: |
    select /* pgwatch_generated */
      (extract(epoch from now()) * 1e9)::int8 as epoch_ns,
      ...
14: |
    select /* pgwatch_generated */
      (extract(epoch from now()) * 1e9)::int8 as epoch_ns,
      ...

[SlavaLenskyy]

git checkout v3.7.0

This helped.

Thanks a lot!