Re: Unwanted debug messages

Hello Joe,
thanks for your prompt reply. You are right, I changed the value of
client_min_messages in the postgresql.conf file to "error" and the
messages stopped appearing.
Do you know of any way to prevent those messages from showing in the
console even if the server sends them? It's not in every server that I
will have that level of privilege.
Thanks again:

Wences

PS: If you don't mind, I would like to copy your reply, with due
attribution to my question at Stack Overflow, so it might also help others.

On 05/08/2013 15:40, Joe Abbate wrote:
> On 05/08/13 14:05, Wenceslao Grillo wrote:
>
>> conn = psycopg2.connect(host="42.42.42.42", port=5432,
>> database="myDB", user="myUser", password="********")
>> if conn is None:
>> sys.exit("Connection failed")
>> print "Connection successful"
>>
>> Prints the following:
>>
>> DEBUG: CommitTransaction
>> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
>> xid/subid/cid: 0/1/0, nestlvl: 1, children:
>> Connection successful
> Those messages are from Postgres itself. The second one is a DEBUG3
> message in the module backend/access/transam/xact.c. I'd look at the
> logging settings in your postgresql.conf.
>
> Joe
>
>