This one time, at band camp, Paolo Lucente wrote: >Few things about the configuration which may help. You are noticing that the >connection >to PostgreSQL fails; is your PostgreSQL daemon listening on 127.0.0.1:5432 ? >The above >configuration sports a 'sql_host' line which tells the PostgreSQL library to >not use its >usual pipe file connectin but go TCP instead. Here might lie the trouble, let >me know. > >About the error message; you are right: it's quite generic; i'll add a >specific text for >each of the 3 cases "lock failure", "unable to connect" and "at least one of >the queries >has failed" so that they are easily recognizable.
Turns out I'm an idiot; I hadn't granted pmacct the right privileges to write to the test table :) But it would be nice to have seen that straight up with pmacctd logging the connection error from libpq.