Re: Re: Unknown token in connection string

I think, it's not very clear from documentation, when user see "connection string" ,they will tempt to use password as well , as one normally do.
http://www.pgadmin.org/docs/1.20/commandline.html

regards,
Prasad
 
 

Sent: Thursday, March 05, 2015 at 8:53 AM
From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: Prasad <prasad(dot)s(at)mail(dot)com>
Cc: "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org>, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Subject: Re: [pgadmin-support] Re: Unknown token in connection string
On Wed, Mar 4, 2015 at 10:54 PM, Prasad <prasad(dot)s(at)mail(dot)com> wrote:
> Looking at code, it looks like "connection string", is not expecting any password and will prompt for one. May well possibly a bug.

No, it's a security "feature". Using passwords on the command line is
a bad idea as other users can see it in ps output etc. Use a
PGPASSFILE instead.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com[http://www.enterprisedb.com]
The Enterprise PostgreSQL Company