PostgreSQL 9.1 SPI

[Puneet Kishor]

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