From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Sam Steingold Newsgroups: gmane.emacs.devel Subject: Re: (sql-postgres-login-params): Add user and database defaults. Date: Mon, 10 Nov 2014 16:15:45 -0500 Organization: disorganization Message-ID: References: <1614810674.176716.1415576364167.JavaMail.yahoo@jws10675.mail.bf1.yahoo.com> Reply-To: sds@gnu.org NNTP-Posting-Host: plane.gmane.org Mime-Version: 1.0 Content-Type: text/plain X-Trace: ger.gmane.org 1415654189 3305 80.91.229.3 (10 Nov 2014 21:16:29 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Mon, 10 Nov 2014 21:16:29 +0000 (UTC) To: emacs-devel@gnu.org Original-X-From: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Mon Nov 10 22:16:25 2014 Return-path: Envelope-to: ged-emacs-devel@m.gmane.org Original-Received: from lists.gnu.org ([208.118.235.17]) by plane.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1XnwJy-0007VV-B9 for ged-emacs-devel@m.gmane.org; Mon, 10 Nov 2014 22:16:22 +0100 Original-Received: from localhost ([::1]:45143 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XnwJx-0005bF-Q0 for ged-emacs-devel@m.gmane.org; Mon, 10 Nov 2014 16:16:21 -0500 Original-Received: from eggs.gnu.org ([2001:4830:134:3::10]:45706) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XnwJc-0005b7-OK for emacs-devel@gnu.org; Mon, 10 Nov 2014 16:16:04 -0500 Original-Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XnwJY-0000BH-Os for emacs-devel@gnu.org; Mon, 10 Nov 2014 16:16:00 -0500 Original-Received: from plane.gmane.org ([80.91.229.3]:59631) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XnwJY-0000BB-IF for emacs-devel@gnu.org; Mon, 10 Nov 2014 16:15:56 -0500 Original-Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1XnwJW-0007A6-US for emacs-devel@gnu.org; Mon, 10 Nov 2014 22:15:54 +0100 Original-Received: from 66.9.135.66 ([66.9.135.66]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 10 Nov 2014 22:15:54 +0100 Original-Received: from sds by 66.9.135.66 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 10 Nov 2014 22:15:54 +0100 X-Injected-Via-Gmane: http://gmane.org/ Original-Lines: 54 Original-X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: 66.9.135.66 User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.0.50 (darwin) X-Attribution: Sam X-Disclaimer: You should not expect anyone to agree with me. Cancel-Lock: sha1:Q+eECGrI5bMA/wyOaT/eiX8qy/I= X-detected-operating-system: by eggs.gnu.org: Genre and OS details not recognized. X-Received-From: 80.91.229.3 X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Original-Sender: emacs-devel-bounces+ged-emacs-devel=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.devel:176714 Archived-At: > * Michael Mauger [2014-11-09 23:39:24 +0000]: > >> On Friday, November 7, 2014 2:37 PM, Sam Steingold wrote: > >> Michael, >> Why did you add defaults to the sql-postgres-login-params option? >> No other sql--login-params have them. >> (The list also misses the password, but that was even before your >> 36827ec251bb18183110463a83d55b205653fd5d commit). >> Thanks. > > > That was a commit from 4 years ago; I have problems remembering last week. :-) > A few related items: > > * The defaults specified in the login-params are the same as the psql > program, but I am certainly open to changing the defaults or > eliminating them entirely if people agree. I don't use PG often so > I'm certainly open to feedback from regular users of it. And > obviously, you can customize its value to suit your workflow better. I don't think these defaults are useful (to put it mildly). > * The reason that there is no support for entering the password in > postgres is that there is no command line option or syntax available > to pass the value in `psql'. "psql -W" forces password prompt, so, I think, there should be a way for me to tell emacs which password to use. > There is a long open bug report identifying passing passwords on the > command line as being a security risk, but I have not implemented an > alternative mechanism. I am hacking a mechanism currently to not pass > password on the command line and provide it as program input when > prompted. Postgres is one platform that could benefit from such behavior. I know of security implication of passing passwords on the command line, but I disagree that this should be disabled. A note in the man page and the usage message printed by "--help" should be enough. > Any feedback or patches are actively encouraged. Thanks. -- Sam Steingold (http://sds.podval.org/) on darwin Ns 10.3.1343 http://www.childpsy.net/ http://jihadwatch.org http://islamexposedonline.com http://americancensorship.org http://truepeace.org http://honestreporting.com If your VCR is still blinking 12:00, you don't want Linux.