Обсуждение: 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