Marten Lehmann 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.
Regards
Marten
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Read about something called the .pgpass file. There's a way to set a
file that contains the password (pgAdmin will create one autmoatically)
that pgsql will look for before it asks for your password. It's stored in ~/
The solution I use is a bat file that redefines an environment variable
(PGPASSFILE) that points to the file, then runs pg_dumpall.
--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
