Skip site navigation (1) Skip section navigation (2)

Re: .pgpass

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-novice(at)postgresql(dot)org
Subject: Re: .pgpass
Date: 2004-07-02 08:47:56
Message-ID: 1088758075.574.3997.camel@linda (view raw or flat)
Thread:
Lists: pgsql-novice
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 


In response to

Responses

pgsql-novice by date

Next:From: Aarni RuuhimäkiDate: 2004-07-02 16:16:43
Subject: Re: Formatting text strings in fields
Previous:From: Jason DavisDate: 2004-07-02 05:39:59
Subject: Re: Why this does not work ??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group