Re: .pgpass

On Thu, 2004-07-01 at 18:26, ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca wrote:
> On Thu, 1 Jul 2004, Tom Lane 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.

> Well, if I 'su - postgres' from root, and then run
> 'psql template1' everything works fine. I suppose I could edit
> the .pgpass to contain a bad password, and see if psql fails. If
> I put a bad password in .pgpass, the attempt to try psql fails.
> So, psql is using .pgpass.

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.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1