gabrielle <gorthx(at)gmail(dot)com> writes:
> Hello!
>
> I'm running 9.1.11 on CentOS. I'm getting several messages like this in my logs:
> 2014-09-12 01:44:25.583 PDT,,,30540,,4dbffb0c.7b5b,5,,2014-09-12 01:41:42 PDT,74/868,0,LOG,55P03,"skipping analyze of ""foo"" --- lock not available",,,,,,
>
> Unfortunately, I have several databases with tables named 'foo'. I was expecting a db name in the log message; can someone explain why it's not there?
Fix your log_line_prefix setting to include DB name and then HUP your server.
>
> Thanks!
>
> gabrielle
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800