Re: pgAdmin 1.8RC1 - failed to launch on Mac OS X

[giannibruno]

> Hi everybody! I'm having problems with launching pgAdmin (versions  
> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin  
> application, it just crashes every time. The bug is 100% reproducible.

Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX  
10.5, the icon bounces a few times and the pgAdmin3 name appears in  
the menu bar but nothing else, I then have to force quit.

This is on a PPC Powermac G5, whereas same OS and pgAdmin version on  
an Intel MacBook Pro works perfectly.
Phill

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Dave Page-3]

Phill wrote:

>
>> Hi everybody! I'm having problems with launching pgAdmin (versions
>> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin
>> application, it just crashes every time. The bug is 100% reproducible.
>
> Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX
> 10.5, the icon bounces a few times and the pgAdmin3 name appears in the
> menu bar but nothing else, I then have to force quit.
>
> This is on a PPC Powermac G5, whereas same OS and pgAdmin version on an
> Intel MacBook Pro works perfectly.
> Phill

I'm in the process of procuring some new kit to test on Leopard with.
Please bear with me...

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Dave Page-3]

Phill wrote:

>
>> Hi everybody! I'm having problems with launching pgAdmin (versions
>> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin
>> application, it just crashes every time. The bug is 100% reproducible.
>
> Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX
> 10.5, the icon bounces a few times and the pgAdmin3 name appears in the
> menu bar but nothing else, I then have to force quit.
>
> This is on a PPC Powermac G5, whereas same OS and pgAdmin version on an
> Intel MacBook Pro works perfectly.

Would you mind trying the build at
http://developer.pgadmin.org/~dpage/pgadmin3-1.9.dmg please?

Thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[giannibruno]

On 01/nov/07, at 13:34, Dave Page wrote:

>>> Hi everybody! I'm having problems with launching pgAdmin (versions
>>> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin
>>> application, it just crashes every time. The bug is 100%  
>>> reproducible.
>>
>> Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX
>> 10.5, the icon bounces a few times and the pgAdmin3 name appears in  
>> the
>> menu bar but nothing else, I then have to force quit.
>>
>> This is on a PPC Powermac G5, whereas same OS and pgAdmin version  
>> on an
>> Intel MacBook Pro works perfectly.
>
> Would you mind trying the build at
> http://developer.pgadmin.org/~dpage/pgadmin3-1.9.dmg please?
>
> Thanks, Dave

Same behaviour I'm afraid, still won't open.
Phill

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@... so that your
       message can get through to the mailing list cleanly

[Dave Page-3]

Phill wrote:

>
> On 01/nov/07, at 13:34, Dave Page wrote:
>>>> Hi everybody! I'm having problems with launching pgAdmin (versions
>>>> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin
>>>> application, it just crashes every time. The bug is 100% reproducible.
>>>
>>> Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX
>>> 10.5, the icon bounces a few times and the pgAdmin3 name appears in the
>>> menu bar but nothing else, I then have to force quit.
>>>
>>> This is on a PPC Powermac G5, whereas same OS and pgAdmin version on an
>>> Intel MacBook Pro works perfectly.
>>
>> Would you mind trying the build at
>> http://developer.pgadmin.org/~dpage/pgadmin3-1.9.dmg please?
>>
>> Thanks, Dave
>
> Same behaviour I'm afraid, still won't open.
> Phill

OK, thanks. I should be able to test on Leopard in a few days so I'll
come back to it then.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Dave Page-3]

Phill wrote:

>
> On 01/nov/07, at 13:34, Dave Page wrote:
>>>> Hi everybody! I'm having problems with launching pgAdmin (versions
>>>> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin
>>>> application, it just crashes every time. The bug is 100% reproducible.
>>>
>>> Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX
>>> 10.5, the icon bounces a few times and the pgAdmin3 name appears in the
>>> menu bar but nothing else, I then have to force quit.
>>>
>>> This is on a PPC Powermac G5, whereas same OS and pgAdmin version on an
>>> Intel MacBook Pro works perfectly.
>>
>> Would you mind trying the build at
>> http://developer.pgadmin.org/~dpage/pgadmin3-1.9.dmg please?
>>
>> Thanks, Dave
>
> Same behaviour I'm afraid, still won't open.

Hi Phill,

I was able to test on a PPC/Leopard box over the weekend, and pgAdmin
worked perfectly. Can you provide more info about your machine please -
language/locale in particular. Also, are you about to build form source
and run it up in the debugger?

Regards Dave

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@... so that your
       message can get through to the mailing list cleanly

[giannibruno]

On 05/nov/07, at 10:26, Dave Page wrote:

> Phill wrote:
>>
>>>> Similar problem here, can't get latest v1.8.0 it to launch on Mac  
>>>> OSX
>>>> 10.5, the icon bounces a few times and the pgAdmin3 name appears  
>>>> in the
>>>> menu bar but nothing else, I then have to force quit.
>>>>
>>>> This is on a PPC Powermac G5, whereas same OS and pgAdmin version  
>>>> on an
>>>> Intel MacBook Pro works perfectly.
>>>
>>> Would you mind trying the build at
>>> http://developer.pgadmin.org/~dpage/pgadmin3-1.9.dmg please?
>>>
>>> Thanks, Dave
>>
>> Same behaviour I'm afraid, still won't open.
>
> I was able to test on a PPC/Leopard box over the weekend, and pgAdmin
> worked perfectly. Can you provide more info about your machine  
> please -
> language/locale in particular. Also, are you about to build form  
> source
> and run it up in the debugger?
>
> Regards Dave

Hi Dave
In International preferences the Language is "British English" and the  
Region (Formats tab) is "Italy (Italian)", Currency Euro.
I'll send the full system profile separately.

I'm not experienced in building software for the Mac but I've got  
XCode installed and I'm happy to give it a go if you have some  
instructions I can follow.
Thanks and regards
Phill

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[chokladzingo]

giannibruno wrote:

> Hi everybody! I'm having problems with launching pgAdmin (versions  
> from 1.6.x to 1.8) on Mac OS X 10.4.10. When i try lo launch PgAdmin  
> application, it just crashes every time. The bug is 100% reproducible.

Similar problem here, can't get latest v1.8.0 it to launch on Mac OSX  
10.5, the icon bounces a few times and the pgAdmin3 name appears in  
the menu bar but nothing else, I then have to force quit.

This is on a PPC Powermac G5, whereas same OS and pgAdmin version on  
an Intel MacBook Pro works perfectly.
Phill

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

I have the same problem with pgAdmin 1.8.0 (and 1.9 linked above), on a PowerBook G4 1.33 GHz running OS X Leopard. The application bounces in the dock and nothing else happens, and eventually I have to force quit it.

[Dave Page-3]

chokladzingo wrote:
>
> I have the same problem with pgAdmin 1.8.0 (and 1.9 linked above), on a
> PowerBook G4 1.33 GHz running OS X Leopard. The application bounces in the
> dock and nothing else happens, and eventually I have to force quit it.

One thought - these two reports are not the same as the original one
(which was an actual crash) - can you please try removing the pgadmin3
preferences file from ~/Library/Preferences and then starting pgAdmin?

Thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[chokladzingo]

Dave Page-3 wrote:

chokladzingo wrote:
>
> I have the same problem with pgAdmin 1.8.0 (and 1.9 linked above), on a
> PowerBook G4 1.33 GHz running OS X Leopard. The application bounces in the
> dock and nothing else happens, and eventually I have to force quit it.

One thought - these two reports are not the same as the original one
(which was an actual crash) - can you please try removing the pgadmin3
preferences file from ~/Library/Preferences and then starting pgAdmin?

Thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

I have never succesfully launched pgAdmin on this computer so there are no pgAdmin files anywhere in my Library directory. By the way, Activity Monitor reports that once i lanuch pgAdmin it uses all available processor capacity.

Simon

[giannibruno]

On 05/nov/07, at 12:32, chokladzingo wrote:

> Dave Page-3 wrote:
>>
>> chokladzingo wrote:
>>>
>>> I have the same problem with pgAdmin 1.8.0 (and 1.9 linked above),  
>>> on a
>>> PowerBook G4 1.33 GHz running OS X Leopard. The application  
>>> bounces in
>>> the
>>> dock and nothing else happens, and eventually I have to force quit  
>>> it.
>>
>> One thought - these two reports are not the same as the original one
>> (which was an actual crash) - can you please try removing the  
>> pgadmin3
>> preferences file from ~/Library/Preferences and then starting  
>> pgAdmin?
>>
>> Thanks, Dave
>>
> I have never succesfully launched pgAdmin on this computer so there  
> are no
> pgAdmin files anywhere in my Library directory. By the way, Activity  
> Monitor
> reports that once i lanuch pgAdmin it uses all available processor  
> capacity.
>
> Simon

Likewise, I don't have a pgadmin3 preferences file present.
Phill

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Dave Page-3]

Phill wrote:

>> I have never succesfully launched pgAdmin on this computer so there
>> are no
>> pgAdmin files anywhere in my Library directory. By the way, Activity
>> Monitor
>> reports that once i lanuch pgAdmin it uses all available processor
>> capacity.
>>
>> Simon
>
> Likewise, I don't have a pgadmin3 preferences file present.
> Phill

Somehow (and I don't know how yet) I just reproduced this on my PPC box.
Can you please start pgAdmin so it sits on the dock, and then in a
terminal window, run

ps -ef |grep pg_dump

I found I had a zombie pg_dump process (pgAdmin calls pg_dump at startup
to check the version). I then renamed the copy of pg_dump in the pgAdmin
appbundle, and one I had in /usr/local/bin (you might have others in the
path of course). After I killed pgAdmin, it then started just fine.

/D

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@... so that your
       message can get through to the mailing list cleanly

[giannibruno]

On 05/nov/07, at 13:08, Dave Page wrote:

> Phill wrote:
>>> I have never succesfully launched pgAdmin on this computer so there
>>> are no
>>> pgAdmin files anywhere in my Library directory. By the way, Activity
>>> Monitor
>>> reports that once i lanuch pgAdmin it uses all available processor
>>> capacity.
>>>
>>> Simon
>>
>> Likewise, I don't have a pgadmin3 preferences file present.
>> Phill
>
> Somehow (and I don't know how yet) I just reproduced this on my PPC  
> box.
> Can you please start pgAdmin so it sits on the dock, and then in a
> terminal window, run
>
> ps -ef |grep pg_dump
>
> I found I had a zombie pg_dump process (pgAdmin calls pg_dump at  
> startup
> to check the version). I then renamed the copy of pg_dump in the  
> pgAdmin
> appbundle, and one I had in /usr/local/bin (you might have others in  
> the
> path of course). After I killed pgAdmin, it then started just fine.
>
> /D

Yep that's it!
Renamed pg_dump and it starts just fine.
Phill



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

[Dave Page-3]

Phill wrote:
>
> Yep that's it!
> Renamed pg_dump and it starts just fine.

OK, great - now to figure out why...

/D


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@... so that your
       message can get through to the mailing list cleanly

[chokladzingo]

giannibruno wrote:

Yep that's it!
Renamed pg_dump and it starts just fine.
Phill

Yay, that worked fine for me as well! How will the renaming of pg_dump affect the usage of PostgreSQL? I renamed one in /usr/local/bin/ and one in pgAdmin 1.8 and 1.9 respectively. Is there any risk that some automated process in another part of pgAdmin or PostgreSQL will fail since this file cannot be found?

[Dave Page-3]

chokladzingo wrote:

>
>
> giannibruno wrote:
>> Yep that's it!
>> Renamed pg_dump and it starts just fine.
>> Phill
>>
>
> Yay, that worked fine for me as well! How will the renaming of pg_dump
> affect the usage of PostgreSQL? I renamed one in /usr/local/bin/ and one in
> pgAdmin 1.8 and 1.9 respectively. Is there any risk that some automated
> process in another part of pgAdmin or PostgreSQL will fail since this file
> cannot be found?

pgAdmin won't fail - though it will probably not offer you
backup/restore options.

pg_dumpall will fail in PostgreSQL though, as might any cron jobs oyu
have calling pg_dump.

One workaround that should work would be to create a shell script called
that echoes the same text as output from 'pg_dump --version' and point
pgAdmin's PostgreSQL Bin Dir config option (under File -> Options) to
the directory containing the script. That should fool pgAdmin into using
the shell script for backups (which won't work, but won't hang either),
which will cause it to leave the real pg_dump alone.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

[Dave Page-3]

Phill wrote:
> Yep that's it!
> Renamed pg_dump and it starts just fine.

OK, can you put pg_dump back and try this version please?
http://developer.pgadmin.org/~dpage/pgadmin3-dev.dmg

Thanks, Dave

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[giannibruno]

On 07/nov/07, at 16:35, Dave Page wrote:
> Phill wrote:
>> Yep that's it!
>> Renamed pg_dump and it starts just fine.
> OK, can you put pg_dump back and try this version please? http://developer.pgadmin.org/~dpage/pgadmin3-dev.dmg
>
> Thanks, Dave

Works perfectly :)
Many thanks

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Dave Page-3]

Phill wrote:

> On 07/nov/07, at 16:35, Dave Page wrote:
>> Phill wrote:
>>> Yep that's it!
>>> Renamed pg_dump and it starts just fine.
>> OK, can you put pg_dump back and try this version please?
>> http://developer.pgadmin.org/~dpage/pgadmin3-dev.dmg
>>
>> Thanks, Dave
>
> Works perfectly :)

Great, thanks for testing.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org