Re: Re: Unknown token in connection string

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: Re: Unknown token in connection string
Date: 2015-03-05 08:53:04
Message-ID: CA+OCxoxGdeV4N+t0sRkAYeE2hORZA8_xQVO7ftfjT6PL=9WVjg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Prasad 2015-03-05 09:59:33 Re: Re: Unknown token in connection string
Previous Message Jim Nasby 2015-03-05 08:25:42 Re: Re: [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary