BUG #5930: Increasing log level to debug5 database not working - Mailing list pgsql-bugs

From thiruppathi
Subject BUG #5930: Increasing log level to debug5 database not working
Date
Msg-id 201103151120.p2FBKD4l037745@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5930: Increasing log level to debug5 database not working
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5930
Logged by:          thiruppathi
Email address:      tgandhi@prion-group.com
PostgreSQL version: 9.0
Operating system:   windows server standard
Description:        Increasing log level to debug5 database not working
Details:

If i increase log level to debug5 in postgresql.conf file my database
connection not working i am getting error like follows so please give me
solution or any thing i should do for recover this problem.

 forked new backend, pid=2720 socket=744
2011-03-15 16:27:51 CET DEBUG:  postgres child[2720]: starting with (
2011-03-15 16:27:51 CET DEBUG:      postgres
2011-03-15 16:27:51 CET DEBUG:      1Unified
2011-03-15 16:27:51 CET DEBUG:  )
2011-03-15 16:27:51 CET DEBUG:  InitPostgres
2011-03-15 16:27:51 CET DEBUG:  my backend id is 3
2011-03-15 16:27:51 CET DEBUG:  StartTransaction
2011-03-15 16:27:51 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:27:52 CET DEBUG:  received password packet
2011-03-15 16:27:52 CET DEBUG:  CommitTransaction
2011-03-15 16:27:52 CET DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:27:52 CET DEBUG:  StartTransactionCommand
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:27:52 CET DEBUG:  StartTransaction
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:27:52 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:27:52 CET DEBUG:  CommitTransactionCommand
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:27:52 CET DEBUG:  CommitTransaction
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:27:52 CET DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:27:52 CET STATEMENT:  select oid, typbasetype from pg_type
where typname = 'lo'
2011-03-15 16:28:01 CET DEBUG:  StartTransaction
2011-03-15 16:28:01 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:28:01 CET DEBUG:  CommitTransaction
2011-03-15 16:28:01 CET DEBUG:  name: unnamed; blockState:       STARTED;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:28:01 CET DEBUG:  StartTransaction
2011-03-15 16:28:01 CET DEBUG:  name: unnamed; blockState:       DEFAULT;
state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children:
2011-03-15 16:28:01 CET DEBUG:  CommitTransaction

pgsql-bugs by date:

Previous
From: "Tambet Matiisen"
Date:
Subject: BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5930: Increasing log level to debug5 database not working