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? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
