这是indexloc提供的服务,不要输入任何密码
Skip to content

Query tool not working on shared servers #5533

@net-expertise

Description

@net-expertise

On a clean installation of PgAdmin in server mode, based on the official Docker image version 6.15 I have the following issue:

  1. Add a shared server in chart eg:
    serverDefinitions: enabled: true servers: grafana: Name: "grafana" Group: "Shared" Host: "10.1.1.1" Port: 5432 MaintenanceDB: "postgres" Username: "admin" SSLMode: "prefer" Shared: true SSLCert: "/grafana/postgresql.crt" SSLKey: "/grafana/postgresql.key" SSLRootCert: "/grafana/root.crt" SSLCompression: 0
  2. Logged in as an unprivileged oauth user, I can browse to schema -> tables, click on View/Edit Data, it is showing the data.
    If I click on query tool, and run a simple SELECT * from my_table (any table that has data), I am getting 0 of 0 rows
    Note the connection status icon remains desperately "unplugged" as opposed to when I go to "view data".
    The behaviour is the same if I click on the query tool button in the top bar.
    Creating a new connection doesn't help either.
    This works just fine on a non-shared server.

pg_unplugged

Metadata

Metadata

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions