Обсуждение: PostgreSQL 9 Mac OS X one-click install - PL/perl broken
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
On Mon, Sep 27, 2010 at 11:35 PM, Larry Leszczynski <larryl@emailplus.org> 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
On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" <dpage@pgadmin.org> 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
On Tue, Sep 28, 2010 at 6:46 PM, Larry Leszczynski <larryl@emailplus.org> wrote: > > On Tue, 28 Sep 2010 13:35 +0100, "Dave Page" <dpage@pgadmin.org> 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
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
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 bootedinto. -- Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice
On Tue, Sep 28, 2010 at 7:46 PM, Scott Ribe <scott_ribe@killerbytes.com> 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 bootedinto. 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