On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu <gfu@xxxxxxxxxxxxxx> wrote:
Hello,
I'm running an application (with programs in Perl) through pgpool 3.1 with replication mode to two postgresql db servers (version 9.0.13). Recently, I noticed that the following messages repeatedly showed in postgres log files. As far as I know, the application programs do not make any specific lock on the 'file' table. I'm not sure if it is caused by the pgpool or something else.
Try setting your log_line_prefix so that more details are logged, that might help track down where the locks etc are coming from.
Eg
Eg
log_line_prefix = '%m [%p] (user=%u) (db=%d) (rhost=%h) [vxid:%v txid:%x] [%i] '
and reload your config (eg. "select pg_reload_conf()" as the superuser)
