Building the nginx module – ngx_postgres

I stumbled across a nifty little module for nginx called ngx_postgres.  It allows you to access a Postgres database directly through nginx and HTTP with little more than a configuration file that creates a REST mapping to your tables.  Interesting idea so I thought I’d give it a spin and see if it could be useful, however there were a couple of “gotchas” in setting it up that I thought I’d document.

First adding modules to nginx requires recompiling nginx so you’ve got to get your hands a little dirty to get it going.  I’m currently running Debian 6 in a hosted environment so I’ll give you the blow by blow based on my config.

(more…)

No tags Hide