Re: Windows 10 - pg4 Query Initialization Issue

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(dot)vashi(at)enterprisedb(dot)com> wrote:

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

--

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