Обсуждение: pgadmin3 server status windows completely blank
I posted the following to the pdadmin-support mailing list with no replies. I am trying it here as the issue may be so simple that no one will reply in more experienced mailing lists. A reference for other people having the same problem is: http://postgresql.nabble.com/Server-Status-window-displays-nothing-td5847831.html Basically, will this ever work in Ubuntu? It looks like something quite basic, not data related but the windows are not even being generated - i.e. no headings, columns. -------------------------------------------------------------------------------- Very new user. Problem: Server Status has no data in Activity, Locks, Prepared Transactions windows. 100% repeatable though restarts, etc. Ubuntu 15.10 PostgreSQL 9.4 and 9.5 pgadminIII 1.20 and 1.22 logfile window does work, per proper log set up in postgresql.conf SQL Editor query: SELECT * FROM pg_stat_activity returns expected connection information. So the connections are there. I have seen a few similar posts in 2015, with no response, or resolutions. Nothing more from internet searches. No clues from 9.4 manual. My experience in other forums is such a problem has such an obvious solution that it is staring me right in the face. Is there some setting, plugin, permission, role I am missing? Other than that I have the databases working with a higher level app, successfully backup and restore, moving data around; not bragging, but to indicate I have been successful at something. I have attached the log output that appears synced to the server status refresh.
Still no response from the mailing list, but here is my latest debug: I found that pgadmin3 1.18 does work on ubuntu 14.04. The Server Status shows data and heading/columns properly. I then set about to compile pgadmin3 source 1.18 on another Ubuntu machine (15.04) because it is not available in the distro or PPA for Wily. I got this done and it also works properly re the Server Status windows. In so doing I ensured that all similar dependencies were installed for the machines on which I have admin3 1.20 and 1.22. But still to no avail. (except the -dev versions, so I yet have to try this - these of course were needed for the compile of 1.18). At this point it appears that pgadmin3 1.20/1.22 does not work properly on Ubuntu. I may continue to try on different distros, but I am getting tired of it. The problem with pgadmin3 1.18 is that it is not supposed to be compatible beyond postgresql 9.3, so to use it I will have to down-grade to postgresql 9.3. It does work with 9.5 but with dire warnings. It would be really nice to hear from someone out there. At least so I stop trying out things that are a waste of time. Please advise: should I submit a bug report for pgadmin3 1.20/1.22 on Ubuntu 15?? On Sun, 2016-01-31 at 13:43 -0700, StanC wrote: > I posted the following to the pdadmin-support mailing list with no > replies. > > I am trying it here as the issue may be so simple that no one will reply > in more experienced mailing lists. > > A reference for other people having the same problem is: > > http://postgresql.nabble.com/Server-Status-window-displays-nothing-td5847831.html > > > Basically, will this ever work in Ubuntu? It looks like something quite > basic, not data related but the windows are not even being generated - > i.e. no headings, columns. > > > -------------------------------------------------------------------------------- > > Very new user. > > Problem: Server Status has no data in Activity, Locks, Prepared > Transactions windows. 100% repeatable though restarts, etc. > > Ubuntu 15.10 > PostgreSQL 9.4 and 9.5 > pgadminIII 1.20 and 1.22 > > logfile window does work, per proper log set up in postgresql.conf > > SQL Editor query: SELECT * FROM pg_stat_activity returns expected > connection information. So the connections are there. > > > I have seen a few similar posts in 2015, with no response, or > resolutions. Nothing more from internet searches. No clues from 9.4 > manual. > > > My experience in other forums is such a problem has such an obvious > solution that it is staring me right in the face. > > > Is there some setting, plugin, permission, role I am missing? > > > Other than that I have the databases working with a higher level app, > successfully backup and restore, moving data around; not bragging, but > to indicate I have been successful at something. > > > I have attached the log output that appears synced to the server status > refresh. > > >
Continuing the conversation with myself, I have added the failure that is produced when first accessing the Server Status. It looks like a Wx issue. Can anyone shed light? Please? On Mon, 2016-02-01 at 17:24 -0700, StanC wrote: > Still no response from the mailing list, but here is my latest debug: > > I found that pgadmin3 1.18 does work on ubuntu 14.04. The Server Status > shows data and heading/columns properly. > > I then set about to compile pgadmin3 source 1.18 on another Ubuntu > machine (15.04) because it is not available in the distro or PPA for > Wily. I got this done and it also works properly re the Server Status > windows. > > In so doing I ensured that all similar dependencies were installed for > the machines on which I have admin3 1.20 and 1.22. But still to no > avail. (except the -dev versions, so I yet have to try this - these of > course were needed for the compile of 1.18). > > At this point it appears that pgadmin3 1.20/1.22 does not work properly > on Ubuntu. I may continue to try on different distros, but I am getting > tired of it. > > The problem with pgadmin3 1.18 is that it is not supposed to be > compatible beyond postgresql 9.3, so to use it I will have to down-grade > to postgresql 9.3. It does work with 9.5 but with dire warnings. > > It would be really nice to hear from someone out there. At least so I > stop trying out things that are a waste of time. > > Please advise: should I submit a bug report for pgadmin3 1.20/1.22 on > Ubuntu 15?? > > > > > On Sun, 2016-01-31 at 13:43 -0700, StanC wrote: > > I posted the following to the pdadmin-support mailing list with no > > replies. > > > > I am trying it here as the issue may be so simple that no one will reply > > in more experienced mailing lists. > > > > A reference for other people having the same problem is: > > > > http://postgresql.nabble.com/Server-Status-window-displays-nothing-td5847831.html > > > > > > Basically, will this ever work in Ubuntu? It looks like something quite > > basic, not data related but the windows are not even being generated - > > i.e. no headings, columns. > > > > > > -------------------------------------------------------------------------------- > > > > Very new user. > > > > Problem: Server Status has no data in Activity, Locks, Prepared > > Transactions windows. 100% repeatable though restarts, etc. > > > > Ubuntu 15.10 > > PostgreSQL 9.4 and 9.5 > > pgadminIII 1.20 and 1.22 > > > > logfile window does work, per proper log set up in postgresql.conf > > > > SQL Editor query: SELECT * FROM pg_stat_activity returns expected > > connection information. So the connections are there. > > > > > > I have seen a few similar posts in 2015, with no response, or > > resolutions. Nothing more from internet searches. No clues from 9.4 > > manual. > > > > > > My experience in other forums is such a problem has such an obvious > > solution that it is staring me right in the face. > > > > > > Is there some setting, plugin, permission, role I am missing? > > > > > > Other than that I have the databases working with a higher level app, > > successfully backup and restore, moving data around; not bragging, but > > to indicate I have been successful at something. > > > > > > I have attached the log output that appears synced to the server status > > refresh. > > > > > > > > > >
Вложения
StanC wrote: > Continuing the conversation with myself, I have added the failure that > is produced when first accessing the Server Status. It looks like a Wx > issue. > > Can anyone shed light? Please? Maybe you should write to one of the pgadmin- lists. I don't think this list (or any of the pgsql- lists) are intended to cover pgAdmin. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services