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> >
