Re: Windows 10 - pg4 Query Initialization Issue

Adding pgAdmin Support....

On Thu, Jun 14, 2018 at 9:32 PM, Michael Zsolt <michael(dot)zsolt(at)gmail(dot)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(dot)vashi(at)enterprisedb(dot)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(dot)zsolt(at)gmail(dot)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(dot)vashi(at)enterprisedb(dot)com> wrote:
>>>
>>>>
>>>>
>>>> On Mon, Jun 11, 2018 at 7:32 PM, Michael Zsolt <michael(dot)zsolt(at)gmail(dot)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(dot)zsolt(at)gmail(dot)com>
>>>>> Date: Sun, Jun 10, 2018 at 9:25 AM
>>>>> Subject: Windows 10 - pg4 Query Initialization Issue
>>>>> To: <dpage(at)pgadmin(dot)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(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>>>>> --
>>>>>
>>>>> Michael Zsolt, HBA 2012
>>>>> Director of Analytics, Kitchener Rangers
>>>>> T: (416)-721-5927
>>>>> E: michael(dot)zsolt(at)gmail(dot)com
>>>>>
>>>>
>>>>
>>>
>>> --
>>>
>>> *Michael Zsolt*, HBA 2012
>>> Director of Analytics, Kitchener Rangers
>>> T: (416) 721-5927
>>> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>>>
>>
>>
>
> --
>
> *Michael Zsolt*, HBA 2012
> Director of Analytics, Kitchener Rangers
> T: (416) 721-5927
> E: michael(dot)zsolt(at)gmail(dot)com <MZsolt(dot)HBA2012(at)ivey(dot)ca>
>