Re: backing up Query Editor files
cool thanks. It would be nice if there was an easy way to make backups or for an admin to download those files via the GUI. Derek On Sun, May 12, 2019 at 10:57 PM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Fri, May 10, 2019 at 8:23 PM Derek Ealy > wrote: > >> Hi >> >> We have a fair number of files that we saved in the query editor from >> multiple users. Where are these files located? We're running PGAdmin4 in >> server mode. >> >> On Windows: %APPDATA%\pgAdmin\storage > Other platforms: /var/lib/pgadmin/storage > > Thanks, Derek >> >> -- >> dme >> >> >> *Derek Ealy* >> Sr. Software Architect >> >> NovaWurks, Inc. >> 10772 Noel Street >> Los Alamitos, CA 90720 >> P: 562.340.6270 <562.340.6270%20x%20700> >> F: 877.353.7537 >> C: 310.936.4070 <801.319.4613> >> >> www.novawurks.com >> >> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company >> confidential information proprietary to NovaWurks Corporation or its >> customers and may be confidential, legally privileged, and protected by >> law. If you are not the intended recipient you may not use, disclose, >> distribute, copy, print, or rely on this e-mail. If you have received this >> transmission in error please notify the sender and destroy the original >> transmission and its attachments without reading or saving. Thank you. >> > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
backing up Query Editor files
Hi We have a fair number of files that we saved in the query editor from multiple users. Where are these files located? We're running PGAdmin4 in server mode. Thanks, Derek -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
no grid displayed in Chrome
I just upgraded to v3.1 and now I am not getting any grid displays or query editors when using pgAdmin in Chrome. Everything seems to be fine when using Firefox however. In chrome things look pretty normal until I try to get a query window. The connection icon in the upper left is the only thing visible in the query window and it shows that the connection is broken. However I know this is incorrect since it works fine in FF. Also in Chrome the Dashboard seems fine and I can see that the connection is in fact working correctly. It seems like maybe there is something in Chrome that is cached that is messing things up, possibly? Any ideas how to get things working properly in v3.1? Thanks, Derek -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Re: My pgAdmin is broken
Well then thanks to Kushboo also On Thu, Apr 19, 2018 at 9:09 AM, Isaias Sanchez <isaias.sanche...@gmail.com> wrote: > The solution was thanks to Khushboo Vashi 'cause I reported this issue > yesterday. > > https://redmine.postgresql.org/issues/3296 > Let us know if it works for you. > > > Derek Ealy wrote on 04/19/2018 04:04 PM: > > Allriiigghht Isaias!! > > Man thanks, I was so freakin' annoyed at this upgrade not working and how > frustrating recovering from it was. I'm glad you figured out what the > problem was, I had never even heard of pycrypto before to day. > > Awesomesauce > > On Thu, Apr 19, 2018 at 8:57 AM, Isaias Sanchez < > isaias.sanche...@gmail.com> wrote: > >> I also had this problem, but the issue is some incompatibilities in >> pycryptodome and pycrypto: >> >> 1. Install v3.0: >> >> pip install ./pgadmin4-3.0-py2.py3-none-any.whl >> >> 2. Unistall pycryptodome: >> >> pip uninstall pycryptodome >> >> 3. Uninstall/Install pgcrypto: >> >> pip uninstall pycrypto >> >> pip3 install pycrypto >> >> 4. Start pgadmin4: >> >> python /usr/local/lib/python/site-packages/pgadmin4/pgAdmin4.py & >> >> Go to: http://127.0.0.1:5050 >> >> After that v3.0 works just fine. >> >> Cheers, >> >> Isaias S. >> Derek Ealy wrote on 04/19/2018 03:18 PM: >> >> A couple of days ago I tried upgrading to v3.0. This never worked for me. >> Normally I activate the python environment and then install the latest >> wheel file to upgrade. I was never able to login successfully on v3.0. >> >> So I gave up and tried to go back to v2.1, again I did so by reinstalling >> the v2.1 wheel file. However afterwards I can't launch pgAdmin. I get this >> error message: >> >> alembic.util.exc.CommandError: Can't locate revision identified by >> '50aad68f99c2' >> >> I've now burned several hours on trying to fix this. What is the best way >> to at least get back to a working system with v2.1? In the future is there >> some better way to upgrade or revert to a previous version when things go >> wrong? >> >> Thanks, Derek >> >> -- >> dme >> >> >> *Derek Ealy* >> Sr. Software Architect >> >> NovaWurks, Inc. >> 10772 Noel Street >> Los Alamitos, CA 90720 >> P: 562.340.6270 <562.340.6270%20x%20700> >> F: 877.353.7537 >> C: 310.936.4070 <801.319.4613> >> >> www.novawurks.com >> >> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company >> confidential information proprietary to NovaWurks Corporation or its >> customers and may be confidential, legally privileged, and protected by >> law. If you are not the intended recipient you may not use, disclose, >> distribute, copy, print, or rely on this e-mail. If you have received this >> transmission in error please notify the sender and destroy the original >> transmission and its attachments without reading or saving. Thank you. >> >> >> > > > -- > dme > > > *Derek Ealy* > Sr. Software Architect > > NovaWurks, Inc. > 10772 Noel Street > Los Alamitos, CA 90720 > P: 562.340.6270 <562.340.6270%20x%20700> > F: 877.353.7537 > C: 310.936.4070 <801.319.4613> > > www.novawurks.com > > CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company > confidential information proprietary to NovaWurks Corporation or its > customers and may be confidential, legally privileged, and protected by > law. If you are not the intended recipient you may not use, disclose, > distribute, copy, print, or rely on this e-mail. If you have received this > transmission in error please notify the sender and destroy the original > transmission and its attachments without reading or saving. Thank you. > > > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Re: My pgAdmin is broken
Allriiigghht Isaias!! Man thanks, I was so freakin' annoyed at this upgrade not working and how frustrating recovering from it was. I'm glad you figured out what the problem was, I had never even heard of pycrypto before to day. Awesomesauce On Thu, Apr 19, 2018 at 8:57 AM, Isaias Sanchez <isaias.sanche...@gmail.com> wrote: > I also had this problem, but the issue is some incompatibilities in > pycryptodome and pycrypto: > > 1. Install v3.0: > > pip install ./pgadmin4-3.0-py2.py3-none-any.whl > > 2. Unistall pycryptodome: > > pip uninstall pycryptodome > > 3. Uninstall/Install pgcrypto: > > pip uninstall pycrypto > > pip3 install pycrypto > > 4. Start pgadmin4: > > python /usr/local/lib/python/site-packages/pgadmin4/pgAdmin4.py & > > Go to: http://127.0.0.1:5050 > > After that v3.0 works just fine. > > Cheers, > > Isaias S. > Derek Ealy wrote on 04/19/2018 03:18 PM: > > A couple of days ago I tried upgrading to v3.0. This never worked for me. > Normally I activate the python environment and then install the latest > wheel file to upgrade. I was never able to login successfully on v3.0. > > So I gave up and tried to go back to v2.1, again I did so by reinstalling > the v2.1 wheel file. However afterwards I can't launch pgAdmin. I get this > error message: > > alembic.util.exc.CommandError: Can't locate revision identified by > '50aad68f99c2' > > I've now burned several hours on trying to fix this. What is the best way > to at least get back to a working system with v2.1? In the future is there > some better way to upgrade or revert to a previous version when things go > wrong? > > Thanks, Derek > > -- > dme > > > *Derek Ealy* > Sr. Software Architect > > NovaWurks, Inc. > 10772 Noel Street > Los Alamitos, CA 90720 > P: 562.340.6270 <562.340.6270%20x%20700> > F: 877.353.7537 > C: 310.936.4070 <801.319.4613> > > www.novawurks.com > > CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company > confidential information proprietary to NovaWurks Corporation or its > customers and may be confidential, legally privileged, and protected by > law. If you are not the intended recipient you may not use, disclose, > distribute, copy, print, or rely on this e-mail. If you have received this > transmission in error please notify the sender and destroy the original > transmission and its attachments without reading or saving. Thank you. > > > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
My pgAdmin is broken
A couple of days ago I tried upgrading to v3.0. This never worked for me. Normally I activate the python environment and then install the latest wheel file to upgrade. I was never able to login successfully on v3.0. So I gave up and tried to go back to v2.1, again I did so by reinstalling the v2.1 wheel file. However afterwards I can't launch pgAdmin. I get this error message: alembic.util.exc.CommandError: Can't locate revision identified by '50aad68f99c2' I've now burned several hours on trying to fix this. What is the best way to at least get back to a working system with v2.1? In the future is there some better way to upgrade or revert to a previous version when things go wrong? Thanks, Derek -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Re: pgadmin4.3 - login failure
I am also having problems logging in since upgrading to pgAdmin4 3.0. Mine are more like those found in this bug: https://redmine.postgresql.org/issues/3297 I also tried using the docker image, but that was even worse, it says that my local postgres server isn't accepting connections. Or if I try to access our dev instance I get a popup box saying "Please log in to access this page" I guess I'm gonna have to revert back to v2.1 On Wed, Apr 18, 2018 at 3:07 AM, Tony Bazeley <to...@sa.apana.org.au> wrote: > On attempting to login to the database server I get an error message > "readonly attribute" - see log entry below > > I'm using postgresql 9.6 on Ubuntu 16.04.4 LTS, installed on a single > user workstation using trust authentication on 127.0.0.1 > pgadmin 4.3 installed using apt from the postgresql repository > > No problems with pgadmin3 or pgadmin 4.21 > > Any thoughts on how to proceed would be much appreciated > > Thanks > > Tony > > > > > 2018-04-18 19:10:59,709: ERRORpgadmin:readonly attribute > Traceback (most recent call last): > File > "/usr/share/pgadmin4/web/pgadmin/browser/server_groups/servers/__init__.py", > line 972, in connect > server_types=ServerType.types() > File "/usr/share/pgadmin4/web/pgadmin/utils/driver/psycopg2/connection.py", > line 313, in connect > pg_conn.notices = deque([], self.ASYNC_NOTICE_MAXLENGTH) > AttributeError: readonly attribute > > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Re: listen/notify not working in pgadmin 4 2.1
I don't think this is the same problem as issue 3094 because I never see the notification at all, whereas the description of issue 3094 says that the notification does appear eventually. On Tue, Mar 13, 2018 at 7:45 AM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > > > On Tue, Mar 13, 2018 at 7:56 PM, Derek Ealy <derek.e...@novawurks.com> > wrote: > >> I was trying to test a notify/listen channel but couldn't get things >> working in PGAdmin4. I'm running it in server mode with Python on Linux. >> Eventually I went back to PGAdmin3 and listened on the same channel and >> everything worked fine. When the notification happened I simply ran: select >> 1; in the same connection and the notify data appeared in the messages tab >> as expected. >> >> When I try the same thing in PGAdmin4 there are no errors, but I cannot >> see anything indicating that a notification was published. >> >> Please have a look @ https://redmine.postgresql.org/issues/3094. > If you are facing this kind of issue mentioned in the RM then, it has been > fixed. > You will get a fix in the upcoming release which is going to be happened > very soon. > >> Is there some other/better way of listening for and seeing notifications >> in PGAdmin4? >> >> Thanks, Derek >> >> -- >> dme >> >> >> *Derek Ealy* >> Sr. Software Architect >> >> NovaWurks, Inc. >> 10772 Noel Street >> <https://maps.google.com/?q=10772+Noel+Street%C2%A0+Los+Alamitos,+CA+90720=gmail=g> >> Los Alamitos, CA 90720 >> <https://maps.google.com/?q=10772+Noel+Street%C2%A0+Los+Alamitos,+CA+90720=gmail=g> >> P: 562.340.6270 <562.340.6270%20x%20700> >> F: 877.353.7537 >> C: 310.936.4070 <801.319.4613> >> >> www.novawurks.com >> >> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company >> confidential information proprietary to NovaWurks Corporation or its >> customers and may be confidential, legally privileged, and protected by >> law. If you are not the intended recipient you may not use, disclose, >> distribute, copy, print, or rely on this e-mail. If you have received this >> transmission in error please notify the sender and destroy the original >> transmission and its attachments without reading or saving. Thank you. >> > > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
listen/notify not working in pgadmin 4 2.1
I was trying to test a notify/listen channel but couldn't get things working in PGAdmin4. I'm running it in server mode with Python on Linux. Eventually I went back to PGAdmin3 and listened on the same channel and everything worked fine. When the notification happened I simply ran: select 1; in the same connection and the notify data appeared in the messages tab as expected. When I try the same thing in PGAdmin4 there are no errors, but I cannot see anything indicating that a notification was published. Is there some other/better way of listening for and seeing notifications in PGAdmin4? Thanks, Derek -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Re: Upgraded to v2.1 now Query Tool not working
Great that worked, thanks. One other question. Our server is still at pgAdmin4 < 2.0. I never upgraded it because when I upgraded to 2.0 on my notebook all of my saved sql files were no longer available. Where are those files stored? Is there a simple way to backup and restore those files? Thanks, Derek On Fri, Jan 12, 2018 at 8:57 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Looks like browser cache issue to me, Can you hard refresh Chrome (using > 3rd option in screenshot) and check again? > > On Fri, Jan 12, 2018 at 10:08 PM, Derek Ealy <derek.e...@novawurks.com> > wrote: > >> Hi >> >> I'm on Ubuntu using the wheel version of pgAdmin4 v2.1, which I upgraded >> to this morning. There were no apparent errors during the upgrade process, >> after having restarted things I can no longer use the Query Tool in Google >> Chrome. The page comes up empty except for a blue bar separating the button >> bar from the editor below. >> >> None of the buttons react on the button bar. >> >> I tried using it from the latest version of Firefox and the Query Tools >> seems to be working fine. >> >> How can I get this working on Chrome? >> >> Thanks, Derek >> >> -- >> dme >> >> >> *Derek Ealy* >> Sr. Software Architect >> >> NovaWurks, Inc. >> 10772 Noel Street >> <https://maps.google.com/?q=10772+Noel+Street%C2%A0Los+Alamitos,+CA+90720=gmail=g> >> Los Alamitos, CA 90720 >> <https://maps.google.com/?q=10772+Noel+Street%C2%A0Los+Alamitos,+CA+90720=gmail=g> >> P: 562.340.6270 <562.340.6270%20x%20700> >> F: 877.353.7537 >> C: 310.936.4070 <801.319.4613> >> >> www.novawurks.com >> >> CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company >> confidential information proprietary to NovaWurks Corporation or its >> customers and may be confidential, legally privileged, and protected by >> law. If you are not the intended recipient you may not use, disclose, >> distribute, copy, print, or rely on this e-mail. If you have received this >> transmission in error please notify the sender and destroy the original >> transmission and its attachments without reading or saving. Thank you. >> > > -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
Upgraded to v2.1 now Query Tool not working
Hi I'm on Ubuntu using the wheel version of pgAdmin4 v2.1, which I upgraded to this morning. There were no apparent errors during the upgrade process, after having restarted things I can no longer use the Query Tool in Google Chrome. The page comes up empty except for a blue bar separating the button bar from the editor below. None of the buttons react on the button bar. I tried using it from the latest version of Firefox and the Query Tools seems to be working fine. How can I get this working on Chrome? Thanks, Derek -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.
error loading script after updating to 1.6
hi, after upgrading from 1.5 to 1.6 today I've been getting errors in Chrome. It says error loading script and points to a pga_job.js. The only way I've been able to clear this error is to clear my browser cache (which is a total pain for all the disruption it causes). I run the python version of PGAdmin4 on Ubuntu. I usually use the server version hosted on one of our AWS machines. But lately it has been having trouble when working with a local instance of Postgres running on my dev machine (SSL SYSCALL error: EOF detected) I don't know why all of the sudden I have been having the server instance of PGAdmin connect to my local DB. It has been working successfully for a couple of months at least. So I updated my local instance of PGAdmin on my dev machine to 1.6 and now I'm again getting these loading script errors. And I'm not wanting to clear my browser cache again. Any suggestions? -- dme *Derek Ealy* Sr. Software Architect NovaWurks, Inc. 10772 Noel Street Los Alamitos, CA 90720 P: 562.340.6270 <562.340.6270%20x%20700> F: 877.353.7537 C: 310.936.4070 <801.319.4613> www.novawurks.com CONFIDENTIALITY NOTICE: This e-mail, including attachments, is company confidential information proprietary to NovaWurks Corporation or its customers and may be confidential, legally privileged, and protected by law. If you are not the intended recipient you may not use, disclose, distribute, copy, print, or rely on this e-mail. If you have received this transmission in error please notify the sender and destroy the original transmission and its attachments without reading or saving. Thank you.