quick answer: research/read the pg_hba.conf in the data directory.

Jeff MacDonald wrote:

Hi,

WHen i run pg_dumpall as the super user [postgres in my case] it asks
for a password for every database. I don't know my users passwords. Is
there a way to make the super user able to backup without passwords ?

Thanks.

Jeff.



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





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

Reply via email to