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

Re: postgresql db account

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org, Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
Subject: Re: postgresql db account
Date: 2006-10-05 12:21:04
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
On Thursday 05 October 2006 08:17, Ray Stell wrote:
> On Thu, Oct 05, 2006 at 08:06:06AM -0400, Sean Davis wrote:
> > On Thursday 05 October 2006 07:47, Ray Stell wrote:
> > > If I change the challange method to md5, I have to know the passwd.
> > > So, are you saying that it is good practice to leave local connections
> > > as trust?  This doesn't seem right to me.  I either have to set the
> > > pw or leave it as trust.
> >
> > The idea of trust on the local machine is that every user on the local
> > machine is allowed direct access to the database, which is a convenience
> > mechanism. If that doesn't meet your needs, then by all means, feel free
> > to set up whatever security you like.  I tend to leave the local machine
> > (to which I am the only person with access) as trust for convenience, but
> > all other machines use md5.
> Thanks, again, someone said there was no pw on the account, but if I set
> local md5 I am prompted for a pw.  Enter doesn't let you in.  Is the
> default known?  Is there an issue with reseting the pw to a known value?

If you don't remember it, set up to use trust on the local machine, log in, 
and then change the password.

Then change back to some other authen method.


In response to


pgsql-novice by date

Next:From: Ray StellDate: 2006-10-05 12:54:22
Subject: Re: postgresql db account
Previous:From: Ray StellDate: 2006-10-05 12:17:27
Subject: Re: postgresql db account

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