On Jun 30, 2015, at 1:59 PM, Kyle Birkeland <kbirkela@utk.edu> wrote:
Signed PGP part Hello,
I'm trying to use a postgresql database in a redundant block on v3.0.8 like so:
redundant { pgsql detail ok }
Unfortunately, whenever a request hits this part of the config, it hangs for over 120 seconds waiting for the connection to set up before moving down the redundant block.
PQconnectdb() does have a connect_timeout option to configure how long the function will wait before returning an error, but I don't see a way to configure this in FR. mod_instantiate() in rlm_sql_postgresql.c looks like it only supports the dbname, host, port, user, password, and application_name.
Would it be possible to get a patch that will add a connect_timeout option to the rlm_sql_postgresql config? It would be greatly appreciated.
https://github.com/FreeRADIUS/freeradius-server/blob/v3.1.x/raddb/mods-avail... The contents of that config item gets passed to PQconnectdb, so you can set whatever options you need there. -Arran