Re: Scheduled back up

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

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

Thanks for information.
But this is not really a problem because apache doesn't have any grants on
database.
It launches a script that connects to db with a diff username [each username
has a unique password].

So if it has only one password on .pgpass only one user can log in.

>
>
>
>
>