Hi -

I use Dave Page's one-click installers for Mac OS X:

http://www.enterprisedb.com/products/pgdownload.do#osx

I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8. PL/perl will
not load because it is looking for Perl 5.10 in the System dirs and I
only have 5.8.8:

$ ./createlang plperl my_db
createlang: language installation failed: ERROR: could not load
library "/Library/PostgreSQL/9.0/lib/postgresql/plperl.so":
dlopen(/Library/PostgreSQL/9.0/lib/postgresql/plperl.so, 10):
Library not loaded: /System/Library/Perl/lib/5.10/libperl.dylib
Referenced from:
/Library/PostgreSQL/9.0/lib/postgresql/plperl.so
Reason: image not found

I tried building plperl.so from source and copied it to
/Library/PostgreSQL/9.0/lib/postgresql/plperl.so. But then I get a
different error:

$ ./createlang plperl my_db
createlang: language installation failed: ERROR: could not load
library "/Library/PostgreSQL/9.0/lib/postgresql/plperl.so":
dlopen(/Library/PostgreSQL/9.0/lib/postgresql/plperl.so, 10):
no suitable image found. Did find:
/Library/PostgreSQL/9.0/lib/postgresql/plperl.so: mach-o,
but wrong architecture

even though the plperl.so I built looks ok:

$ file plperl.so
plperl.so: Mach-O bundle i386

Has anyone else run into this? Anybody have any suggestions?


Thanks!
Larry

Search Discussions

  • Dave Page at Sep 28, 2010 at 12:35 pm

    On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski wrote:
    Hi -

    I use Dave Page's one-click installers for Mac OS X:

    http://www.enterprisedb.com/products/pgdownload.do#osx

    I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8.  PL/perl will
    not load because it is looking for Perl 5.10 in the System dirs and I
    only have 5.8.8:
    <grumble>. That's a PITA. We build on Snow Leopard now, because we
    were getting more requests for x86_64 support than PPC.
    even though the plperl.so I built looks ok:

    $ file plperl.so
    plperl.so: Mach-O bundle i386

    Has anyone else run into this?  Anybody have any suggestions?
    I could understand that if it's running the 64 bit image in the
    binary, but that shouldn't be the case on Leopard I don't think -
    unless this is Leopard Server? If so, you could try building the 64
    bit binary:

    CFLAGS="-isysroot /Developer/SDKs/MacOSX10.5.sdk
    -mmacosx-version-min=10.5 -O2 -arch x86_64" ./configure....

    --
    Dave Page
    Blog: http://pgsnake.blogspot.com
    Twitter: @pgsnake

    EnterpriseDB UK: http://www.enterprisedb.com
    The Enterprise Postgres Company
  • Larry Leszczynski at Sep 28, 2010 at 5:46 pm

    On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" wrote:
    I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8.  PL/perl will
    not load because it is looking for Perl 5.10 in the System dirs and I
    only have 5.8.8:
    <grumble>. That's a PITA. We build on Snow Leopard now, because we
    were getting more requests for x86_64 support than PPC.

    [snip]

    you could try building the 64 bit binary:

    CFLAGS="-isysroot /Developer/SDKs/MacOSX10.5.sdk
    -mmacosx-version-min=10.5 -O2 -arch x86_64" ./configure....
    Excellent! Looks like that worked fine. I just added the "--with-perl"
    option to configure.

    Thanks Dave!

    Larry
  • Dave Page at Sep 28, 2010 at 5:50 pm

    On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski wrote:
    On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" wrote:

    I recently installed PostgreSQL 9.0.0 on Mac OS X 10.5.8.  PL/perl will
    not load because it is looking for Perl 5.10 in the System dirs and I
    only have 5.8.8:
    <grumble>. That's a PITA. We build on Snow Leopard now, because we
    were getting more requests for x86_64 support than PPC.

    [snip]

    you could try building the 64 bit binary:

    CFLAGS="-isysroot /Developer/SDKs/MacOSX10.5.sdk
    -mmacosx-version-min=10.5 -O2 -arch x86_64" ./configure....
    Excellent!  Looks like that worked fine.  I just added the "--with-perl"
    option to configure.

    Thanks Dave!
    You're welcome. I guess it is running the 64bit image - is your
    machine Leopard Server?

    --
    Dave Page
    Blog: http://pgsnake.blogspot.com
    Twitter: @pgsnake

    EnterpriseDB UK: http://www.enterprisedb.com
    The Enterprise Postgres Company
  • Larry Leszczynski at Sep 28, 2010 at 6:23 pm
    Hi Dave -
    you could try building the 64 bit binary:

    CFLAGS="-isysroot /Developer/SDKs/MacOSX10.5.sdk
    -mmacosx-version-min=10.5 -O2 -arch x86_64" ./configure....
    Excellent!  Looks like that worked fine.  I just added the "--with-perl"
    option to configure.

    Thanks Dave!
    You're welcome. I guess it is running the 64bit image - is your
    machine Leopard Server?
    Not sure how I would check... sw_vers give me:

    ProductName: Mac OS X
    ProductVersion: 10.5.8
    BuildVersion: 9L31a


    Thanks!
    Larry
  • Scott Ribe at Sep 28, 2010 at 6:46 pm

    On Sep 28, 2010, at 11:50 AM, Dave Page wrote:

    You're welcome. I guess it is running the 64bit image - is your
    machine Leopard Server?
    That's irrelevant. The 32-bit vs 64-bit default is for the kernel and extensions, not for applications. On 64-bit hardware, apps can be run as 64-bit, and will be if there's a 64-bit executable, regardless of which mode the kernel is booted into.

    --
    Scott Ribe
    [email protected]
    http://www.elevated-dev.com/
    (303) 722-0567 voice
  • Dave Page at Sep 29, 2010 at 8:47 am

    On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe wrote:
    On Sep 28, 2010, at 11:50 AM, Dave Page wrote:

    You're welcome. I guess it is running the 64bit image - is your
    machine Leopard Server?
    That's irrelevant. The 32-bit vs 64-bit default is for the kernel and extensions, not for applications. On 64-bit hardware, apps can be run as 64-bit, and will be if there's a 64-bit executable, regardless of which mode the kernel is booted into.
    Thanks for the clarification. I thought it was only Snow Leopard/Snow
    Leopard Server and Leopard Server that could run the 64 bit images.


    --
    Dave Page
    Blog: http://pgsnake.blogspot.com
    Twitter: @pgsnake

    EnterpriseDB UK: http://www.enterprisedb.com
    The Enterprise Postgres Company

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedSep 27, '10 at 10:41p
activeSep 29, '10 at 8:47a
posts7
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2023 Grokbase