Search Postgresql Archives

Re: automating backup ?

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

 



Zlatko Matic schrieb:

Now I have pgpass.conf file in D:\Documents and Settings\Zlatko\Application Data\postgresql
content of pgpass.conf is:
localhost:*:MONITORINGZ:postgres:tralalala

content of backup_script.bat is:
cd D:\Program Files\PostgreSQL\8.0\bin
pg_dumpall >D:\MONITORINGZ_DUMPALL -U postgres

still prompts for password...What is wrong ?


Perhaps its like this.
pg_dumpall wants to dump the whole database-cluster (every database in your server) that is not only "MONITORINGZ" but the two templates, too. So pg_dumpall doesn't ask you for the password to your own database but 2 times for the pw for the 2 template DBs.

In pgpass.conf write * instead of MONITORINGZ or copy the line for template0 and template1.
Or don't use pg_dumpall and use pg_dump instead just for MONITORINGZ.

Maybe it's somerthing else ... one never knows with those computers ... ;)


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[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