Search Postgresql Archives

Re: How to automate password requests?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wednesday 28 November 2007, Marten Lehmann <lehmann@xxxxxx> wrote:
> Hello,
>
> I'm trying to automate some postgresql scripts, but I cannot find a way
> to pass a password directly to commands like pg_dump psql and so on.
> Even a
>
> echo "password" | psql
>
> doesn't work, the password prompt of psql is still waiting.
>
> mysql has the -p option. What would be the postgresql equivalent? I
> don't want to enter passwords dozend times.
>

create a .pgpass file.

-- 
The global consumer economy can best be described as the most efficient way  
to convert natural resources into waste.


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux