"Viorel Dragomir" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]