Re: .pgpass

On Fri, 2 Jul 2004, Oliver Elphick wrote:

> > > <ghaverla@freenet.edmonton.ab.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