Extension .control file?

[decibel]

Where is the extension control file? Is there a way to install this somewhere that doesn't have apt?

[daamien]

Hi !

Thanks for your interest in this piece of code. There's no control file because it's not a PostgreSQL extension per se. This is just a foreign data wrapper based on multicorn. I could make it an extension but I didn't feel the need to because this FDW is basically a proof of concept.

If you want to install it you need to install multicorn first
http://multicorn.readthedocs.org/en/latest/installation.html

The simply run :
$ sudo python setup.py install

And restart the PostgreSQL service
$ sudo service postgresql restart

You can now launch test.sql with a superuser

Out of curiosity, what are you trying to achieve this FDW ? Personnally I use it to extract some stats from the FDW page ont the postgresql wiki and don't see many other use cases.

[daamien]

FTR I just switched to python 3 and pushed a docker image. you can just type

docker run -p 65432:5432 -d daamien/fdw_fdw

and then:

psql -h 127.0.0.1 -p 65432 -U postgres -c "SELECT * FROM wrappers;"

[decibel]

There's no control file
because it's not a PostgreSQL extension per se.

Ahh, I was confused by the CREATE EXTENSION in test.sql; I didn't read
it closely enough to see what extension it was actually installing.

Out of curiosity, what are you trying to achieve this FDW ? Personnally
I use it to extract some stats from the FDW page ont the postgresql wiki
and don't see many other use cases.

Yeah, I just gave a talk at Scale that mentioned FDWs and I wanted a

count of how many there are. :)

Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

[daamien]

As of today, there's 98 FDW on the wiki page, although some NoSQL wrappers look very dubious