Postgres Pro
Downloads
Home   >   mailing lists

Re: log message from autovac doesn't include db name - Mailing list pgsql-admin

From Jerry Sievers
Subject Re: log message from autovac doesn't include db name
Date
Msg-id 864mw7ze8c.fsf@jerry.enova.com
Whole thread Raw
In response to log message from autovac doesn't include db name  (gabrielle <gorthx@gmail.com>)
Responses Re: log message from autovac doesn't include db name
List pgsql-admin
Tree view 
gabrielle <gorthx@gmail.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; 
cansomeone 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.consulting@comcast.net
p: 312.241.7800

pgsql-admin by date:

Previous
From: Alexey Klyukin
Date:
Subject: Re: Standby is not removing restored WAL segments
Next
From: Matheus de Oliveira
Date:
Subject: Re: log message from autovac doesn't include db name