| From: | <ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca> |
|---|---|
| To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: .pgpass |
| Date: | 2004-07-04 19:41:37 |
| Message-ID: | Pine.A41.3.95.1040704133943.20448B-100000@fn2.freenet.edmonton.ab.ca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, 2 Jul 2004, Oliver Elphick wrote:
> > > <ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca> writes:
> >
> > > > I'm running Debian unstable, and I keep getting a message from a
> > > > cron job that wants to do.maintenance about no password being
> > > > supplied.
> I suggest you edit /usr/lib/postgresql/bin/do.maintenance and add a line
> set -x
> at line 2. Then you will be able to see exactly what command it is
> trying to run.
++ /usr/bin/psql -q -X -t -d template1 -P border=0 -c '
SELECT datname
FROM pg_database
WHERE datallowconn
ORDER BY datname'
Password:
psql: fe_sendauth: no password supplied
+ dblist=
+ IFS=
+ /usr/bin/psql -d template1 -t -q -X
Password:
psql: fe_sendauth: no password supplied
My guess is it is that -X (disallow reading of a .psqlrc file) is
somehow turning off the reading of any .pgpass file.
Gord
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Elphick | 2004-07-04 21:21:10 | Re: .pgpass |
| Previous Message | R.Welz | 2004-07-04 12:43:36 | plpgsql in RULE possible? |