Re: pg_dump

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump
Date: 2003-07-29 16:47:39
Message-ID: 20030729164739.GH9011@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 28, 2003 at 07:18:13PM +0200, Frank Finner wrote:
> Hi,
>
> surely you are right. I?m still using 7.2.3 as production database, so I
> have no experience with .pgpass. Where to put .pgpass if you use pg_dump
> from a PHP script and the database user is not a system user?

I think you need the .pgpass in the home directory of the user
running the server processing the PHP (e.g. ~apache or ~nobody or
whatever you use). I'm not sure how well it will work, though, given
that those users typically have /bin/false as a shell. I haven't
tested it.

A

----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-07-29 16:51:18 Re: Clone a database to other machine
Previous Message Ian Barwick 2003-07-29 16:36:21 Re: Auto completion in psql