BUG #5930: Increasing log level to debug5 database not working

From: "thiruppathi" <tgandhi(at)prion-group(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5930: Increasing log level to debug5 database not working
Date: 2011-03-15 11:20:13
Message-ID: 201103151120.p2FBKD4l037745@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5930
Logged by: thiruppathi
Email address: tgandhi(at)prion-group(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2011-03-15 14:02:52 Re: BUG #5930: Increasing log level to debug5 database not working
Previous Message Tambet Matiisen 2011-03-15 09:28:29 BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342