Skip site navigation (1) Skip section navigation (2)

Re: .pgpass

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 (view raw or flat)
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


In response to

  • Re: .pgpass at 2004-07-02 08:47:56 from Oliver Elphick

Responses

  • Re: .pgpass at 2004-07-04 21:21:10 from Oliver Elphick

pgsql-novice by date

Next:From: Oliver ElphickDate: 2004-07-04 21:21:10
Subject: Re: .pgpass
Previous:From: R.WelzDate: 2004-07-04 12:43:36
Subject: plpgsql in RULE possible?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group