On Fri, 2003-07-18 at 15:49, Viorel Dragomir wrote:
> > 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.
>
> In my case the user is apache.
> I dunno for sure but the apache doesn't have a home directory.
>
If you have root access to the box, you can fix that by assigning a home
directory to the apache user in the /etc/passwd file. Just make sure the
shell assigned to the apache user is invalid, so nobody can log in as
apache user.
Cheers,
Csaba.