Обсуждение: Disable sending query to obtain database performance informationfrom pgAdmin4
All,We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.I cannot find anywhere to disable these queries. Please advise on where and how to disable?
RE: Disable sending query to obtain database performance informationfrom pgAdmin4
From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, August 27, 2019 6:01 PM
To: pgsql-admin@postgresql.org
Subject: Disable sending query to obtain database performance information from pgAdmin4
All,
We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.
I cannot find anywhere to disable these queries. Please advise on where and how to disable?
Thanks,
Andy
If you are still using postgresql 8.3, why switching to pgAdmin4? It’s not intended to be used with postgresql 8.3.
Just stay with pgAdmin III.
Regards,
Igor Neyman
Sent from Yahoo Mail for iPad
On Wednesday, August 28, 2019, 10:47 PM, Igor Neyman <ineyman@perceptron.com> wrote:
#yiv5627347758 #yiv5627347758 -- _filtered #yiv5627347758 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv5627347758 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv5627347758 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv5627347758 #yiv5627347758 p.yiv5627347758MsoNormal, #yiv5627347758 li.yiv5627347758MsoNormal, #yiv5627347758 div.yiv5627347758MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New serif;} #yiv5627347758 a:link, #yiv5627347758 span.yiv5627347758MsoHyperlink {color:#0563C1;text-decoration:underline;} #yiv5627347758 a:visited, #yiv5627347758 span.yiv5627347758MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;} #yiv5627347758 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New serif;} #yiv5627347758 span.yiv5627347758EmailStyle18 {font-family:sans-serif;color:#1F497D;} #yiv5627347758 .yiv5627347758MsoChpDefault {font-size:10.0pt;} _filtered #yiv5627347758 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv5627347758 div.yiv5627347758WordSection1 {} #yiv5627347758 From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, August 27, 2019 6:01 PM
To: pgsql-admin@postgresql.org
Subject: Disable sending query to obtain database performance information from pgAdmin4
All,
We have used pgAdmin III for Greenplum database, postgresql 8.2. Recently, we upgraded to Greenplum postgresql 8.3 and switched to pgAdmin4.
We found that pgAdmin4 sends many sqls to obtain database performance, which filled up Greenplum log quickly.
I cannot find anywhere to disable these queries. Please advise on where and how to disable?
Thanks,
Andy
If you are still using postgresql 8.3, why switching to pgAdmin4? It’s not intended to be used with postgresql 8.3.
Just stay with pgAdmin III.
Regards,
Igor Neyman
Вложения
RE: Disable sending query to obtain database performance information from pgAdmin4
From: Andy Hsu [mailto:hhhsu7a@yahoo.com]
Sent: Tuesday, September 24, 2019 1:41 PM
To: Igor Neyman <ineyman@perceptron.com>; pgsql-admin@postgresql.org
Subject: Re: Disable sending query to obtain database performance information from pgAdmin4
WARNING: This email originated from outside of Perceptron! Please be mindful of PHISHING and MALWARE risks.
When using pgAdmin 3 with Greenplum 5 (Postgres 8.3), an error pops up when accessing schema. Then, all view, functions, and sequences are not displayed.
Andy
Meaning, you need to find pgAdmin III version, which is compatible with Postgres 8.3.
Regards,
Igor Neyman