----- Original Message -----
From: "Csaba Nagy" <nagy@ecircle-ag.com>
To: "Viorel Dragomir" <bc@vio.ro>
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>; "Andrew Sullivan"
<andrew@libertyrms.info>; "Pgsql-General" <pgsql-general@postgresql.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.
>
>
>
>
>