Re: .pgpass

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

> 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@lfix.co.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