"Viorel Dragomir" <bc(at)vio(dot)ro> writes:
>> I don't know what a custom user is, but if you put the password in
>> ~/.pgpass, authentication happens automatically. That's a new
>> feature in 7.3.x.
> But I can't do that, the users that are granted to use the database don't
> have any user id on that machine,
> so no /home/user_name directory either.
No, .pgpass is sought in the home directory of the user running pg_dump
(or any other client program). It's not a server-side file.
regards, tom lane