Re: Scheduled back up

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Viorel Dragomir" <bc(at)vio(dot)ro>
Cc: "Andrew Sullivan" <andrew(at)libertyrms(dot)info>; "Pgsql-General"
<pgsql-general(at)postgresql(dot)org>
Sent: Friday, July 18, 2003 4:41 PM
Subject: Re: [GENERAL] Scheduled back up

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

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