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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:47:54
Message-ID: 14352.1174405674@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"filippo" <filippo2991(at)virgilio(dot)it> writes:
> 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).

Create a ~/.pgpass file for the user that runs the cron job.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-03-20 15:54:42 Re: pg installation for dummies
Previous Message Tom Lane 2007-03-20 15:47:01 Re: LISTEN/NOTIFY and python