public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rob Emery <[email protected]>
To: [email protected]
Subject: PGAgent 4.0 error feedback
Date: Sat, 9 Jun 2018 21:56:28 +0100
Message-ID: <CAPCETpsrtBXjssDorG4fc+DZWqcF6U_WWCTtdUFAcMmUFkwkSw@mail.gmail.com> (raw)

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,
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: [email protected] 
<mailto:[email protected]>
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;

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: PGAgent 4.0 error feedback
  In-Reply-To: <CAPCETpsrtBXjssDorG4fc+DZWqcF6U_WWCTtdUFAcMmUFkwkSw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox