Thread: Auto password input

Auto password input

From
Yasuhiro Takahashi
Date:
Hello,

I'm using windows + cygiwin, so I do not know about bash script.

I want to input passward automatically to psql.
When I try 'qspl dbname', always passwad is required.

How to input password automatically?


Thanks.



Re: Auto password input

From
Gaetano Mendola
Date:
Yasuhiro Takahashi wrote:
> Hello,
>
> I'm using windows + cygiwin, so I do not know about bash script.
>
> I want to input passward automatically to psql.
> When I try 'qspl dbname', always passwad is required.
>
> How to input password automatically?

Look at this:

http://developer.postgresql.org/docs/postgres/libpq-pgpass.html


Regards
Gaetano Mendola


Re: Auto password input

From
Lim Seng
Date:
Hi,

Have you tried editing hba_pg.conf under localhost, any user and use
trust for authentication without any password challenge?

Just a thought,
Lim Seng

Yasuhiro Takahashi wrote:

>Hello,
>
>I'm using windows + cygiwin, so I do not know about bash script.
>
>I want to input passward automatically to psql.
>When I try 'qspl dbname', always passwad is required.
>
>How to input password automatically?
>
>
>Thanks.
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>      subscribe-nomail command to majordomo@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>