FRiCKLE / ngx_postgres

upstream module that allows nginx to communicate directly with PostgreSQL database.
http://labs.frickle.com/nginx_ngx_postgres/
BSD 2-Clause "Simplified" License
545 stars 122 forks source link

Building against Postgres 12 #62

Open gettimothy opened 4 years ago

gettimothy commented 4 years ago

Howdy,

First, thank you for your work.

I am running openresty and have been using your module against postgres 11 for some time.

I just upgraded to postgresql 12 and during the configure step of openresty

./configure --with-luajit --without-http_redis2_module --with-pcre-jit --with-http_postgres_module -j2

build, I get:

adding module in ../ngx_postgres-1.0
checking for libpq library version 9.1 ... not found
checking for libpq library version 9.0 ... not found
checking for libpq library version 8.4 ... not found
checking for libpq library version 8.3 ... not found
checking for libpq library version 8.2 ... not found
checking for libpq library version 8.1.4 ... not found
checking for libpq library version 8.1.0 ... not found
checking for libpq library version 8.0.8 ... not found
checking for libpq library version 8.0.0 ... not found

I am on Slackware linux 64 bit and pq libs are in the usual spot:

/usr/local/pgsql/lib# ls -al libpq*
-rw-r--r-- 1 root root 317044 May  1 18:35 libpq.a
lrwxrwxrwx 1 root root     13 May  1 18:35 libpq.so -> libpq.so.5.12*
lrwxrwxrwx 1 root root     13 May  1 18:35 libpq.so.5 -> libpq.so.5.12*
-rwxr-xr-x 1 root root 334592 May  1 18:35 libpq.so.5.12*
-rwxr-xr-x 1 root root  30728 May  1 18:35 libpqwalreceiver.so*

Perhaps it is a problem with my machine (postgres works great.) but I thought I would ask you here.

thank you for your time.

flaki commented 3 years ago

Fwiw I just built this on FreeBSD 12 & the Postgres 12 client and this configured & built cleanly.

pkg install postgresql12-client

# Use ./configure -h to check for other options
./configure --with-http_v2_module --with-http_postgres_module --with-ipv6
(…)
adding module in ../ngx_postgres-1.0
checking for libpq library (via pg_config) ... found
checking for libpq library version 9.1 ... found
 + ngx_postgres was configured
(…)