On Apr 2, 2012, at 4:40 PM, Phil Dobbin wrote:

> -----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.
> 


Yes, which is a significant issue with a port manager. If it provides what you 
want, life is good. If it doesn't, you have to either get it to, or potentially 
run afoul of it.

Hopefully, I will get other suggestions.

--
Puneet Kishor

_______________________________________________
macports-users mailing list
macports-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo.cgi/macports-users

Reply via email to