Re: pg_dump - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: pg_dump
Date
Msg-id 20030729164739.GH9011@libertyrms.info
Whole thread Raw
In response to Re: pg_dump  (Frank Finner <postgresql@finner.de>)
List 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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Clone a database to other machine
Next
From: Elielson Fontanezi
Date:
Subject: ALTER TABLE ... DROP CONSTRAINT