Postgres Pro
Downloads
Home   >   mailing lists

Re: shell script to SQL statement: `pg_dump | psql -U` - Mailing list pgsql-general

From Richard Huxton
Subject Re: shell script to SQL statement: `pg_dump | psql -U`
Date
Msg-id 45FFFCA7.3030605@archonet.com
Whole thread Raw
In response to shell script to SQL statement: `pg_dump | psql -U`  ("filippo" <filippo2991@virgilio.it>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg installation for dummies
Next
From: Josh Berkus
Date:
Subject: Reminder: only 5 days left to submit SoC applications