Re: shell script to SQL statement: `pg_dump | psql -U`

From: Richard Huxton <dev(at)archonet(dot)com>
To: filippo <filippo2991(at)virgilio(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: shell script to SQL statement: `pg_dump | psql -U`
Date: 2007-03-20 15:24:23
Message-ID: 45FFFCA7.3030605@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

filippo wrote:
> The problem with the current implementation is that sometime pd_dump
> and psql ask for password but I want to create the database copy
> without any user typing (it is a cron script)

Consider using the PGPASSWORD environment variable or .pgpass file.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rick Schumeyer 2007-03-20 15:27:35 pg installation for dummies
Previous Message John D. Burger 2007-03-20 15:08:04 LISTEN/NOTIFY and python