rapidloop / pgmetrics

Collect and display information and stats from a running PostgreSQL server
https://pgmetrics.io
Apache License 2.0
960 stars 65 forks source link

Query failed on launch #9

Closed neissa closed 6 years ago

neissa commented 6 years ago

./pgmetrics --no-password pgmetrics: pg_roles/pg_auth_members query failed: pq: bigint en dehors des limites

psql -V psql (PostgreSQL) 10.3 (Debian 10.3-1.pgdg80+1)

mdevan commented 6 years ago

Does any of your roles have "valid until" set as Infinity?

select rolname, rolvaliduntil from pg_roles where rolvaliduntil = 'Infinity';

If so, this should be fixed in pgmetrics v1.1. Please download the v1.1 from here and try with that.

neissa commented 6 years ago

You were rigth, install part of the documentation should be upgrade with this version so no more noob will open issue. With the v1.1it works well.

mdevan commented 6 years ago

Updated documentation, thanks.