-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 02/04/2012 22:24, Puneet Kishor wrote: > > On Apr 2, 2012, at 3:38 PM, Phil Dobbin wrote:
>> On 02/04/2012 20:54, Puneet Kishor wrote: >>> I was hoping to try out the SPI extension with Postgres 9.1, which, per the >>> documentation at http://www.postgresql.org/docs/9.1/static/contrib-spi.html >>> is supposed to live under <path>/to/contrib. But, in my >>> /opt/local/share/postgresql91/contrib I don't have spi. Should I be able to >>> get this via macports, or do I just download Pg sourcecode and look within >>> that? >> >> If it's not available on Mac Ports, you could try PGXN which is >> postgresql's answer to CPAN. >> >> Haven't checked that it's on there but I should think so. If it is, it's >> simply a case of installing the module when you've pointed it at the >> right location by all accounts. >> > > > Interesting... didn't even know of PGXN's existence. Sadly, SPI doesn't seem > to exist on PGXN. And, it also requires installing PGXN client written in > Python, which, hopefully shouldn't be any more difficult that macports, but I > know nothing about Python. > > I downloaded the Pg source code, and that does come with the source for a > boatload of contribs. But, to compile any of those extensions, I need to "run > configure in the top level directory and then run `gmake all`". Well, I don't > know the configure options that macports used when it installed Pg, and I > don't have gmake. I compiled my own pgsql on OS X & it built very easily. The gmake I used, I installed from Mac Ports. But it would definitely wouldn't be advisable to re-run configure against the postgresql you have installed in /opt/local as you say. Cheers, Phil... - -- But masters, remember that I am an ass. Though it be not written down, yet forget not that I am an ass. Wm. Shakespeare - Much Ado About Nothing -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: §auto-key-locate cert pka ldap hkp://keys.gnupg.net Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJPehy1AAoJEKpMeDHWT5ADzKgIANrVvjWURYb4pFxeNjvm57Qq zdeKq+wwMWgVd3oikH/ucfGHgbqyVDZgBhMMUoPEDer8zL40g0/AgdrIlev4w9mV zh5u3GcWIUkTMZAvjsHdZyCZJiGhwjz5J+rPi86pWS1QIW+W0e9/BvNg6VnwvK6s Hfi1VDXgK1SotDhCsNcwszrEJUiS1733FNqBBnz1xxB9aN6LKYE7eI57ZtmLxGx/ 3fi5T/8CmQZpLIFBfbcHO4wccOIvg9S58e/8XzKDNoDLENynk/BNEEKMJ3W5eblY emvxb1ZfdJGtp0AJLozW+9VqwnuniHbmy4Pv8Ne+RyngNxl17pzyfneS2M+0C0o= =/ngc -----END PGP SIGNATURE----- _______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
