Hi Rob, On Mon, Jun 11, 2018 at 9:13 AM, Ashesh Vashi <ashesh.va...@enterprisedb.com > wrote:
> Hi Rob, > > On Sun, Jun 10, 2018 at 2:26 AM, Rob Emery <re-pg...@codeweavers.net> > wrote: > >> Hi Guys, >> >> I've been testing out PGAgent 4 (build today from master at commit >> 86ca5c5ed1ad572075ba27e05e4680ebdf5b9feb) to check the connection >> handling on error is still fixed with the boost reimplementation >> (which it is!) >> and noticed a few issues compared to PGAgent 3 around feedback to the >> user if the connection string is incorrect. >> >> I've tested with incorrect username and password, user not in the hba, >> db doesn't exist, postgresql not running on the host (or incorrect >> hostaddr) and 4 seems to always returns the error : >> ` >> ERROR: Couldn't find the function 'pgagent_schema_version' - please >> run pgagent_upgrade.sql. >> ` >> >> whereas 3.4.1 tends to output from the pgconnection itself like: >> ` >> Sat Jun 9 21:32:13 2018 : WARNING: Couldn't create the primary >> connection (attempt 1): FATAL: no pg_hba.conf entry for host >> "172.30.0.16", user "pgagent_login_role", database >> "pgagent_login_role", SSL on >> FATAL: no pg_hba.conf entry for host "172.30.0.16", user >> "pgagent_login_role", database "pgagent_login_role", SSL off >> ` >> >> which at least points the user towards the actual error! >> >> Not sure if this is known already, but I thought I'd raise it prior to >> release. >> > Thanks for sharing the information. > > Is it possible for you to share the logs with log level set to debug? > Also - please share the operating system details? > I've sent a patch <https://www.postgresql.org/message-id/CAG7mmoy7ruK%3DHZGOt5GTFsuSF5e4%2BzHnagU0hJfuMUhqjZs%3Dmw%40mail.gmail.com> to resolve the issue based on some assumptions, to verify those assumptions I would still like to see the logs (if you can provide), and operating system information. -- 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>* > > -- > > 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> > > > >> >> Thanks, >> Rob >> -- >> >> -- >> <https://codeweavers.net> >> >> >> Codeweavers May Newsletter >> <https://mailchi.mp/codeweavers/march-edition-336883> l Codeweavers >> April >> Finance Trends >> <https://codeweavers.net/company-blog/codeweavers-april-finance-trends> >> >> >> April’s Dealer Highlights >> <https://codeweavers.net/company-blog/aprils-dealer-highlights> >> <https://codeweavers.net/company-blog/codeweavers-march-car- >> finance-trends> >> >> _ >> _ >> >> >> >> *Phone:* 0800 021 0888 Email: contac...@codeweavers.net >> <mailto:contac...@codeweavers.net> >> Codeweavers Ltd | Barn 4 | Dunston >> Business Village | Dunston | ST18 9AB >> Registered in England and Wales No. >> 04092394 | VAT registration no. 974 9705 63 >> >> >> >> >> <https://www.linkedin.com/company/codeweavers-limited> >> <https://vimeo.com/codeweaversltd> >> <https://plus.google.com/b/105942302039373248738/+CodeweaversNet> >> <https://twitter.com/CodeweaversTeam> >> >> >> >
