On Mon, Aug 21, 2017 at 1:41 PM, Dave Page <dp...@pgadmin.org> wrote:
> > > On Mon, Aug 21, 2017 at 6:24 AM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> >> >> On Aug 21, 2017 10:52, "Thomas Krennwallner" <tk+pg...@postsubmeta.net> >> wrote: >> >> On Mon Aug 21, 2017 06:50:03AM +0530, Ashesh Vashi wrote: >> > On Aug 20, 2017 22:48, "Thomas Krennwallner" <[1] >> tk+pg...@postsubmeta.net> >> > wrote: >> > >> > % ./pgagent -f -t60 -l2 dbname=xxx user=tkren connection_timeout=5 >> [...] >> > Sun Aug 20 18:24:34 2017 : DEBUG: Creating DB connection: >> user=tkren connection_timeout=5 dbname=xxx >> > Sun Aug 20 18:24:34 2017 : WARNING: Couldn't create the primary >> connection (attempt 1): invalid connection option "connection_timeout" >> > >> > This suggests pgAgent is not using the latest version of libpq. >> > Please use LD_LIBRARY_PATH environment to inform pgAgent to use the >> libpq, >> > it is compiled with. >> > -- Thanks, >> > Ashesh Vashi >> > -- Thanks, Ashesh >> >> Unfortunately, this does not work. On a current Debian sid system, >> I've compiled pgagent from source and get >> >> % ldd ./pgagent >> [...] >> libpq.so.5 => /usr/lib/x86_64-linux-gnu/libpq.so.5 >> (0x00007ff531382000) >> [...] >> >> >> The system has libpq 9.6.4 installed: >> >> % apt-cache show libpq5 >> Package: libpq5 >> Source: postgresql-9.6 >> Version: 9.6.4-1 >> [...] >> >> You may want set the rpath manually using chrpath utility for testing. >> >> > Regardless of that, connection.cpp does need to be taught the correct name > for connect_timeout, as well as the additional appname related parameters > right? > True. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com/> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >
