----- Original Message ----- From: "Csaba Nagy" <[EMAIL PROTECTED]> To: "Viorel Dragomir" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Andrew Sullivan" <[EMAIL PROTECTED]>; "Pgsql-General" <[EMAIL PROTECTED]> 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. > > > > > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend