Re: pg_dump

From: Frank Finner <postgresql(at)finner(dot)de>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump
Date: 2003-07-28 17:18:13
Message-ID: 20030728191813.61b32881.postgresql@finner.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Greetings,

Frank Finner

On Fri, 25 Jul 2003 17:17:26 -0400 Andrew Sullivan
<andrew(at)libertyrms(dot)info> sat down, thought long and then wrote:

> On Fri, Jul 25, 2003 at 10:20:38PM +0200, Frank Finner wrote:
> > Hi,
> >
> > with PostgreSQL you can do it using the environment variables PGUSER
> > and PGPASSWORD for example in a shellscript like this (bash-syntax):
> ^^^^^^^^^^
>
> But note that that isn't safe. If you're using >= 7.3, you can use
> .pgpass instead, which is much safer.
>
> A

In response to

  • Re: pg_dump at 2003-07-25 21:17:26 from Andrew Sullivan

Responses

  • Re: pg_dump at 2003-07-29 16:47:39 from Andrew Sullivan

Browse pgsql-general by date

  From Date Subject
Next Message Hunter Hillegas 2003-07-28 17:19:37 Re: Can't Build 7.3.4 on OS X
Previous Message Tom Lane 2003-07-28 16:43:56 Re: Using YY-MM-DD date input