Roxen5.2 can't connect to Postgres
Imported from http://bugzilla.roxen.com/bugzilla/show_bug.cgi?id=6328
Reported by Eiichiro ITANI, emu@ceres.dti.ne.jp
I'm trying Roxen5.2.
Through administration interface, add new db connecting external postgres with database uri 'pgsql://user@dbhostname/dbname'.
It raises error:
FATAL 42704: unrecognized configuration parameter "reconnect" (guc.c:set_config_option:5100)
Looking pgsql.pike, I changed line 1071, add "reconnect" in multiset keys.
foreach(options-(<"use_ssl","force_ssl","cache_autoprepared_statements","reconnect">);
string name;mixed value)
I restarted roxen, And accessing DB tab of Admin Interface, I waited very long for server response. I found that roxen was trying to retrieve schema information from newly add postgres database which hold many tables (over 1000). While roxen trying to get schema info from db, another connections to server blocked.
So anyway,
- CRITICAL: "reconnect" option should properly handled or removed with connecting pgsql driver
- WISHLIST: It would be nice working of fetching schema backgrounded.
I hit above problem with Roxen 5.2.191 Pike 7.8.662 Postgresql 9.1.3