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