Re : pg_dump auto login

[Laurent ROCHE <laurent_roche@xxxxxxxxx>]

Warren,

make sure that the pgpass.conf contains the correct entries (server name, user name, password).
If you are prompted for a password, it's because pg_dump could not find a matching entry to what is specified in your pg_dump command.
You can make a test with pgAdmin and if it prompts your for a password then you can type it then and ask to save it (that will be in your pgpass.conf) ... then next time, you will not be prompted any more in pg_dump or pgAdmin.

 

Cheers,
L@u
The Computing Froggy

----- Message d'origine ----
De : Warren <warren@xxxxxxxxxxxxxxxxxxx>
À : pgsql-general@xxxxxxxxxxxxxx
Envoyé le : Mardi, 23 Octobre 2007, 5h37mn 14s
Objet : pg_dump auto login

I have two different machines that run pg_dump in a batch file. One prompts
for a password and the other one does not. I am running version 8.1 on
Windows XP. Both machines have a pgpass.conf file in the right place. The
Administrator user runs the batch file. How do I get pg_dump to run without
prompting for a password?

Thanks,

Warren


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

---

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail