Re: Passing password in psql command

Hi,

for a scripting solution if you don't want to use any possibilities mentioned
before, you might want to have a look at *expect* then to catch the prompt
and send your password.

Alex.

hubert depesz lubaczewski <depesz(at)depesz(dot)com> schrieb am Mo., 2. März 2015
um 10:44 Uhr:

> On Mon, Mar 02, 2015 at 02:57:46PM +0530, Technical Doubts wrote:
> > Dear Team,
> > We are unable to connect to PostgreSQL db using psql by passing password
> > parameter. If we don't give password, then on password promt it's
> accepting
> > the password we type. But our scheduler script is having the psql line
> with
> > password parameter. Helps highly appreciated. Thanks in advance.
>
> There is no option to provide password in command line.
>
> You either have to use environment variable, as described here:
> http://www.postgresql.org/docs/current/interactive/libpq-envars.html
> or pgpass file, as described here:
> http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
>
> Both of these places are listed in docs for psql
> (http://www.postgresql.org/docs/current/interactive/app-psql.html) in
> part "connecting to a database".
>
> depesz
>
> --
> The best thing about modern society is how easy it is to avoid contact
> with it.
>
> http://depesz.com/
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>