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
>
>