Re: .pgpass

On Sun, 2004-07-04 at 20:41, ghaverla@freenet.edmonton.ab.ca wrote:
> + /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.

I can't see how that could be.  -X is a psql option, but .pgpass is read
by the libpq library, which has no knowledge of the psql options.

Can you check that do.maintenance is being run by the correct user? (Put
the line "user identity = `id`" somewhere near the top.)  Also, see if
do.maintenance works when run directly rather than through cron.

--
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