Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lSqtd-0002uJ-3K for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Apr 2021 00:45:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lSqta-00040o-Vy for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Apr 2021 00:45:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lSqta-00040h-QG for pgsql-bugs@lists.postgresql.org; Sun, 04 Apr 2021 00:45:42 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lSqtY-0001Im-1a for pgsql-bugs@lists.postgresql.org; Sun, 04 Apr 2021 00:45:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 1340jaiU089569; Sat, 3 Apr 2021 20:45:36 -0400 From: Tom Lane To: jad.jebara@hyperviewhq.com cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16952: PG admin errors out when connecting via ssh because it can't get pg_settings In-reply-to: <16952-5bb4a207d25ae8ff@postgresql.org> References: <16952-5bb4a207d25ae8ff@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Sat, 03 Apr 2021 23:07:25 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <89567.1617497136.1@sss.pgh.pa.us> Date: Sat, 03 Apr 2021 20:45:36 -0400 Message-ID: <89568.1617497136@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Bug reporting form 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