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
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
In response to
pgsql-novice by date
|Next:||From: Aarni Ruuhimäki||Date: 2004-07-02 16:16:43|
|Subject: Re: Formatting text strings in fields|
|Previous:||From: Jason Davis||Date: 2004-07-02 05:39:59|
|Subject: Re: Why this does not work ??|