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

> 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

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

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

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

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

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

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

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.
--
View this message in context: http://www.nabble.com/Re%3A-pgAdmin-1.8RC1---failed-to-launch-on-Mac-OS-X-tf4713191.html#a13584852
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

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

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
--
View this message in context: http://www.nabble.com/Re%3A-pgAdmin-1.8RC1---failed-to-launch-on-Mac-OS-X-tf4713191.html#a13585161
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

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

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

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

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

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

/D

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?
--
View this message in context: http://www.nabble.com/Re%3A-pgAdmin-1.8RC1---failed-to-launch-on-Mac-OS-X-tf4713191.html#a13588157
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

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.

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

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

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