Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id D032D632843
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 23 Aug 2010 20:48:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 08708-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 23 Aug 2010 23:47:54 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web36907.mail.mud.yahoo.com (web36907.mail.mud.yahoo.com
	[209.191.85.75])
	by mail.postgresql.org (Postfix) with SMTP id 95BDE632694
	for <pgsql-admin@postgresql.org>; Mon, 23 Aug 2010 20:47:55 -0300 (ADT)
Received: (qmail 17903 invoked by uid 60001); 23 Aug 2010 23:47:53 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1282607273; bh=wGF5mxH9Lvmwv6n5IHv5qnzEJ+3eA58/+LMmOvoCuMI=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=274Or0VTglfjyi/iJBP8VXxBLGpMVXAI9P+IMGh1wO9ZlDimbgg+vDqd2/3MLW2bqHwGcY+RGUtcz1OrhXP4JDG2XttNBlCj5Fi3IUGyuon9sahR8qAS+I7YWYILsVtLOK6Ww5Weop4vJhM3fvViyi9YvtivZLruOPhwqxQhA1o=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=seGBsVqJX7qaLAgt7vw+akCAesn9vAC+hlWxqe6ArvHhXTNb5qAKiyvLUIKj2Tmgr9RiTU70uQLgwpviGh3crjCS/N+R4kxPbhZzMhIHYzqryuoWiQH10Eqh9RcnbhQRGh8An6zIMua/8VfuKVbh0lHKXe+UeqingzTghuxc6XA=;
Message-ID: <624891.14568.qm@web36907.mail.mud.yahoo.com>
X-YMail-OSG: 6Cr1XPkVM1nPB4cG9LwB7Z7vw6bnM.2BLdtayVRfIwje8La
	R8jQwZR8wSgks2AoFRNWIsZfpei08SJL0yN9XBSLcfmedw77gkrYmkOq4Z6a
	AH7DqIXPOz_xZVF4DMpjqjYd14j7rOcrXrkSSAlzTQe4p16dx2OGlMB_FV4B
	zj5u_IM0wQWeKC6p.gB8qdPcySd3HHgRNjW9z04_Pfu_HroG8j_8Kg9hgsGN
	J8g.U8IA6ThhnnbW1fAfwYnWnMJ.GneK4ZbDcVk_zqjVDqAWRhHqV3Q4wyRW
	sX14HcEY4dvkqRKIpGpN_w9o2n.T5cv3vbh7.iTzgr96z15ydJZbP
Received: from [71.6.82.226] by web36907.mail.mud.yahoo.com via HTTP;
	Mon, 23 Aug 2010 16:47:53 PDT
X-Mailer: YahooMailRC/470 YahooMailWebService/0.8.105.279950
Date: Mon, 23 Aug 2010 16:47:53 -0700 (PDT)
From: Keith Pinnix <kpinnix@yahoo.com>
Subject: postgresql 8.3  logging user passwords in clear text
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-888677344-1282607273=:14568"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.509 tagged_above=-10 required=5
	tests=BAYES_05=-0.5, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/164
X-Sequence-Number: 35413

--0-888677344-1282607273=:14568
Content-Type: text/plain; charset=us-ascii

All:

I have a postgresql instance and I have noticed that it is logging the user 
passwords in clear text in the postgresql.log.   Is this configurable so that it 
retains the user info and commands but does not log the password?

Keith
--0-888677344-1282607273=:14568
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:10pt"><div>All:<br><br>I have a postgresql instance and I have noticed that it is logging the user passwords in clear text in the postgresql.log.&nbsp;&nbsp; Is this configurable so that it retains the user info and commands but does not log the password?<br><br>Keith<br><br></div>
</div></body></html>
--0-888677344-1282607273=:14568--