----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Viorel Dragomir" <bc@vio.ro>
Cc: "Andrew Sullivan" <andrew@libertyrms.info>; "Pgsql-General"
<pgsql-general@postgresql.org>
Sent: Friday, July 18, 2003 4:41 PM
Subject: Re: [GENERAL] Scheduled back up
> "Viorel Dragomir" <bc@vio.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.
In my case the user is apache.
I dunno for sure but the apache doesn't have a home directory.
I try to find information about pgpass but still i dunno what pgpass should
contain.
a) only one password - of the ~/ user
b) username:password
>
> regards, tom lane