From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Derek Elder <dereke(at)mirthcorp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issue enabling track_counts to launch autovacuum in 9.4.5 |
Date: | 2016-03-02 23:25:21 |
Message-ID: | 1553.1456961121@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> The fact that the first two are only LOG level and not WARNING would seems
> like the easiest improvement to make.
Unfortunately, that would be a disimprovement, because in many common
configurations WARNING messages don't appear in the postmaster log at all.
In fact, I'd say it's a bug that the "autovacuum not started" message is
emitted as a WARNING not LOG.
Maybe we need some way of printing something at LOG priority but having
the printed text be WARNING. I'm afraid that might cause about as much
confusion as it would solve, though.
> It probably would help to specify, if known, whether the suspected
> mis-configuration is external or internal to PostgreSQL - i.e., do I need
> to fix postgres.conf or is something external (like the hosts file) to
> blame.
In the case of a name resolution failure, the problem is certainly
external to Postgres, but we don't have enough information to say more
than that. We could print a hint guessing at causes (like broken
/etc/host or /etc/resolv.conf files), but it would be guesses --- and
I'm afraid there's enough cross-system variation in the way this stuff is
configured that any hint would be likely to just be misleading.
> This is getting a bit deep for a rare problem like this - I think that
> making the root messages WARNING (or ERROR)
ERROR would mean that the postmaster fails to start at all. That doesn't
seem like an improvement either.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-03-02 23:38:37 | Re: Issue enabling track_counts to launch autovacuum in 9.4.5 |
Previous Message | Joshua D. Drake | 2016-03-02 23:20:31 | Re: Issue enabling track_counts to launch autovacuum in 9.4.5 |