BUG #16952: PG admin errors out when connecting via ssh because it can't get pg_settings
The following bug has been logged on the website:
Bug reference: 16952
Logged by: JJebara
Email address: jad.jebara@hyperviewhq.com
PostgreSQL version: 10.5
Operating system: Debian
Description:
I am able to login from terminal and using Postico. But PG admin terminates
there connections because I can't get the Pg_settings.
Is there a way to disable this requirement to log on.
This is he error code I receive
Unable to connect to server: ERROR: permission denied for relation
pg_settings
PG Bug reporting form <noreply@postgresql.org> writes:
I am able to login from terminal and using Postico. But PG admin terminates
there connections because I can't get the Pg_settings.
Is there a way to disable this requirement to log on.
This is he error code I receive
Unable to connect to server: ERROR: permission denied for relation
pg_settings
This seems to be a deficiency in pgAdmin, not the core server,
so this is the wrong place to report it. You should go to the
pgAdmin support lists.
https://www.pgadmin.org/support/list/
regards, tom lane