Hi Michael, Thanks for sharing the proper logs. The similar issue has been reported earlier. Reference: https://redmine.postgresql.org/issues/3433
After checking your logs, it is confirmed that the issue is with version loader on windows and that has been fixed as part of RM #3324 : the https://redmine.postgresql.org/issues/3324. This fix will be available in the next release of pgAdmin 4. Thanks, Khushboo On Thu, Jun 21, 2018 at 12:05 AM, Michael Zsolt <michael.zs...@gmail.com> wrote: > Thanks Kushboo. Just wanted to double check where this stands - is this > something you guys are looking into? I think I can still access and query > my DB using R, but wanted to see if this was 'on the shelf' somewhere or if > its still on your radar. > > Thanks again for your help, > > Mike > > On Fri, Jun 15, 2018 at 1:10 AM Khushboo Vashi < > khushboo.va...@enterprisedb.com> wrote: > >> Adding pgAdmin Support.... >> >> On Thu, Jun 14, 2018 at 9:32 PM, Michael Zsolt <michael.zs...@gmail.com> >> wrote: >> >>> Hi Khushboo, >>> >>> Thanks for the quick follow up. I have attached a new log which appears >>> to relate to pgAdmin 4. Your link was helpful though I have not yet been >>> able to* "create a file called config_local.py"*. I apologize for my >>> naive-ness with pgAdmin and Postgres - some of these issues I have run into >>> on my very first interactions with the software. Is this file attached what >>> you need? If you need me to proceed with creating 'config_local.py', I have >>> a question or two below: >>> >>> 1) For some reason, my pgAdmin folder is under Program Files (where I >>> installed it) and the attached log file was under my 'user' folder >>> - C:\Users\micha. I am guessing this is because I may not be technically >>> the administrator on my computer, but I am not sure >>> >>> 2) It may be due to the the reason above, but I was not able to find a >>> 'config.py' file in general. >>> >>> Let me know what you need and I will continue trying to provide. >>> >>> Thanks again, >>> >>> Mike >>> >>> PS - Ultimately I plan to interact with the database predominately via >>> R. If you know any tutorials focused on 'creating your first PostgreSQL >>> database and connect using R', please pass them along! This Query >>> Initialization issue may no longer be a problem if I could connect in R.... >>> >>> >>> >>> On Thu, Jun 14, 2018 at 6:27 AM Khushboo Vashi < >>> khushboo.va...@enterprisedb.com> wrote: >>> >>>> I was talking about pgAdmin4 log not postgres logs. >>>> Please refer how to enable logginf. >>>> https://www.pgadmin.org/faq/#8 >>>> >>>> On Thu, Jun 14, 2018 at 12:28 PM, Michael Zsolt < >>>> michael.zs...@gmail.com> wrote: >>>> >>>>> Hi there >>>>> >>>>> Happy to help. Unfortunately I am quite new to SQL and postgres. Can >>>>> you walk me through how to turn on debug mode and identify the log files? >>>>> Within my postgres folder I found 3 files under 'data' and 'log' >>>>> subfolders, which I have attached. Mostly these seem to contain info about >>>>> me setting up users/a new table and struggling somewhat. None of them >>>>> explicitly relate to the query initialization error, from what I can tell >>>>> - >>>>> and that is consistent from what I have read on forums from other people >>>>> who have had this problem (i.e. even with debug mode on, nothing shows up >>>>> in logs apparently). You will see that a few moments ago (in 2018-06-10) >>>>> I >>>>> was able to open the query tool for one of the demo schemas I have created >>>>> (only one worked). That said, overall the problem still persists. >>>>> >>>>> Thanks in advance >>>>> >>>>> Mike >>>>> >>>>> >>>>> >>>>> On Thu, Jun 14, 2018 at 2:14 AM Khushboo Vashi < >>>>> khushboo.va...@enterprisedb.com> wrote: >>>>> >>>>>> >>>>>> >>>>>> On Mon, Jun 11, 2018 at 7:32 PM, Michael Zsolt < >>>>>> michael.zs...@gmail.com> wrote: >>>>>> >>>>>>> Hi there >>>>>>> >>>>>>> Please see forwarded email and attachments below. Dave Page passed >>>>>>> along this address after I reached out to him. >>>>>>> >>>>>>> Thank you in advance >>>>>>> >>>>>>> Mike >>>>>>> >>>>>>> >>>>>>> >>>>>>> ---------- Forwarded message --------- >>>>>>> From: Michael Zsolt <michael.zs...@gmail.com> >>>>>>> Date: Sun, Jun 10, 2018 at 9:25 AM >>>>>>> Subject: Windows 10 - pg4 Query Initialization Issue >>>>>>> To: <dp...@pgadmin.org> >>>>>>> >>>>>>> >>>>>>> Hi Dave, >>>>>>> >>>>>>> Hope you are well. I found your information online that you are the >>>>>>> 'maintainer' for pgAdmin. I ran into an issue (which seems to be a >>>>>>> bug?) so >>>>>>> wanted to just flag it to you and provide any helpful info I can about >>>>>>> the >>>>>>> product. I am quite new to PostgreSQL (I have R experience but very >>>>>>> limited >>>>>>> in SQL), so I apologize if my email lacks important details - happy to >>>>>>> provide more upon request. >>>>>>> >>>>>>> The issue is simple - the majority of the time I try to use the >>>>>>> Query Tool in pgAdmin 4 (via web browser), it gives the error message >>>>>>> attached. This happens when I am using the UI or the shortcut keys. >>>>>>> Once or >>>>>>> twice I managed to use the Query Tool successfully, but it is not clear >>>>>>> what was unique in those circumstances. I tried uninstalling and >>>>>>> reinstalling, and I think the successful Query Tools happened as the >>>>>>> *first >>>>>>> couple* tries after I reinstalled - thereafter it has not worked >>>>>>> since. >>>>>>> >>>>>>> The issue seems to have come up on some help forums, so I will try >>>>>>> to answer some of the questions posed there in advance: >>>>>>> >>>>>>> - I am using version 10.4 that I downloaded from this link: >>>>>>> https://www.enterprisedb.com/downloads/ >>>>>>> postgres-postgresql-downloads >>>>>>> >>>>>>> <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads> >>>>>>> - I installed with the auto-install wizard from that link >>>>>>> - Previously I was learning from version 9.X (not sure) which >>>>>>> had a desktop-based client, rather than web-based, and it did not >>>>>>> have this >>>>>>> issue >>>>>>> - I am on 64 bit Windows 10 - system specs also attached in a >>>>>>> screenshot >>>>>>> - I have not attached a log file with debug mode on, but others >>>>>>> seem to have tried that and said 'the log file provides limited >>>>>>> information >>>>>>> to help' >>>>>>> >>>>>>> Log file would be helpful here. Please attach the log file with >>>>>> debug mode on. >>>>>> >>>>>>> I work for an ice hockey team and plan to use postgres to manage our >>>>>>> data next season (starting by the end of the summer) - and am hoping to >>>>>>> keep learning more from now to then. Any guesses when you might have >>>>>>> this >>>>>>> fixed? Or workarounds you would propose in the mean time? I appreciate >>>>>>> your >>>>>>> help and let me know if there is anything else I can do. >>>>>>> >>>>>>> Thanks in advance >>>>>>> >>>>>>> Regards, >>>>>>> >>>>>>> Mike >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> *Michael Zsolt* >>>>>>> Director of Analytics, Kitchener Rangers >>>>>>> E: michael.zs...@gmail.com <mzsolt.hba2...@ivey.ca> >>>>>>> -- >>>>>>> >>>>>>> Michael Zsolt, HBA 2012 >>>>>>> Director of Analytics, Kitchener Rangers >>>>>>> T: (416)-721-5927 >>>>>>> E: michael.zs...@gmail.com >>>>>>> >>>>>> >>>>>> >>>>> >>>>> -- >>>>> >>>>> *Michael Zsolt*, HBA 2012 >>>>> Director of Analytics, Kitchener Rangers >>>>> T: (416) 721-5927 >>>>> E: michael.zs...@gmail.com <mzsolt.hba2...@ivey.ca> >>>>> >>>> >>>> >>> >>> -- >>> >>> *Michael Zsolt*, HBA 2012 >>> Director of Analytics, Kitchener Rangers >>> T: (416) 721-5927 >>> E: michael.zs...@gmail.com <mzsolt.hba2...@ivey.ca> >>> >> >> > > -- > > *Michael Zsolt*, HBA 2012 > Director of Analytics, Kitchener Rangers > T: (416) 721-5927 > E: michael.zs...@gmail.com <mzsolt.hba2...@ivey.ca> >
