| Lists: | pgadmin-support |
|---|
| From: | Manish Jain <maniff(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | |
| Date: | 2011-10-28 02:08:48 |
| Message-ID: | 1508C345-A08F-46BC-ABD5-DF0174456FE7@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
Hi,
I have PostgreSQL9.1 installed on Mac OS X ver 10.7.2 which was working absolutely well up to few weeks ago, but suddenly the query tool has stopped working. Whenever I am trying to open the query tool the PGAdmin the application get hung and I have to use the "force quit" to exit the application and start it again, please help.
Sincerely
Manish Jain
| From: | Manish Jain <maniff(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 02:10:00 |
| Message-ID: | 06D14015-2C39-4247-BE32-A999CC6BF9A5@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
> Hi,
>
> I have PostgreSQL9.1 installed on Mac OS X ver 10.7.2 which was working absolutely well up to few weeks ago, but suddenly the query tool has stopped working. Whenever I am trying to open the query tool the PGAdmin the application get hung and I have to use the "force quit" to exit the application and start it again, please help.
>
> Sincerely
> Manish Jain
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Manish Jain <maniff(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 17:50:53 |
| Message-ID: | 1319824253.2119.3.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
On Thu, 2011-10-27 at 22:10 -0400, Manish Jain wrote:
> > Hi,
> >
> > I have PostgreSQL9.1 installed on Mac OS X ver 10.7.2 which was working absolutely well up to few weeks ago, but suddenly the query tool has stopped working. Whenever I am trying to open the query tool the PGAdmin the application get hung and I have to use the "force quit" to exit the application and start it again, please help.
> >
Delete the .pgadmin_histoqueries file on your PC. It should work better.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From: | Manish Jain <maniff(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 21:01:21 |
| Message-ID: | 2A5623DF-8154-4383-868F-974F75659D56@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
Hello,
I removed .pgadmin_histoqueries file and it worked, but can i know the reason/research behind this issue?
Thanks,
Manish Jain
On Oct 28, 2011, at 1:50 PM, Guillaume Lelarge wrote:
> .pgadmin_histoqueries
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Manish Jain <maniff(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 21:27:01 |
| Message-ID: | 1319837221.2119.12.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
On Fri, 2011-10-28 at 17:01 -0400, Manish Jain wrote:
> Hello,
>
> I removed .pgadmin_histoqueries file and it worked, but can i know the reason/research behind this issue?
>
This file contains your queries history. In the first release of pgAdmin
that uses it, it could grow a lot and pgAdmin can have a hard time
reading it all at the start of the query tool. This bug has been fixed
then, but you can always get hit by it if you didn't upgrade your
pgadmin release or if you already have a too big file.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From: | Manish Jain <maniff(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 21:33:14 |
| Message-ID: | 4E1838A1-48D4-4D12-9E01-F91EFC2C033D@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
Hi Guillaume,
Got this point and I really appreciate your help.
On you suggestion I also upgrade from PostgreSQL 9.0 to 9.1 but my PGAdmin window is showing me both 9.0 & 9.1 servers. Do you I have to uninstall the previous version of the PostgreSQL first? If yes, then how?
Regards,
Manish Jain
On Oct 28, 2011, at 5:27 PM, Guillaume Lelarge wrote:
> On Fri, 2011-10-28 at 17:01 -0400, Manish Jain wrote:
>> Hello,
>>
>> I removed .pgadmin_histoqueries file and it worked, but can i know the reason/research behind this issue?
>>
>
> This file contains your queries history. In the first release of pgAdmin
> that uses it, it could grow a lot and pgAdmin can have a hard time
> reading it all at the start of the query tool. This bug has been fixed
> then, but you can always get hit by it if you didn't upgrade your
> pgadmin release or if you already have a too big file.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Manish Jain <maniff(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 22:16:38 |
| Message-ID: | 1319840198.2119.14.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
On Fri, 2011-10-28 at 17:33 -0400, Manish Jain wrote:
> Hi Guillaume,
>
> Got this point and I really appreciate your help.
> On you suggestion I also upgrade from PostgreSQL 9.0 to 9.1 but my PGAdmin window is showing me both 9.0 & 9.1 servers. Do you I have to uninstall the previous version of the PostgreSQL first? If yes, then how?
>
You should uninstall the oldest release if you don't need it anymore.
There is an uninstaller in its directory.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From: | Manish Jain <maniff(at)gmail(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: SQL Query tool in PGAdmin causing exception |
| Date: | 2011-10-28 22:53:25 |
| Message-ID: | D24F8A16-97CB-4461-AE92-8D2366F01312@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgadmin-support |
Its working now. Thanks again.
Regards
Manish Jain
On Oct 28, 2011, at 6:16 PM, Guillaume Lelarge wrote:
> On Fri, 2011-10-28 at 17:33 -0400, Manish Jain wrote:
>> Hi Guillaume,
>>
>> Got this point and I really appreciate your help.
>> On you suggestion I also upgrade from PostgreSQL 9.0 to 9.1 but my PGAdmin window is showing me both 9.0 & 9.1 servers. Do you I have to uninstall the previous version of the PostgreSQL first? If yes, then how?
>>
>
> You should uninstall the oldest release if you don't need it anymore.
> There is an uninstaller in its directory.
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>