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: | 200610050821.04858.sdavis2@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
http://www.postgresql.org/docs/8.1/interactive/sql-alteruser.html
Then change back to some other authen method.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Ray Stell | 2006-10-05 12:54:22 | Re: postgresql db account |
Previous Message | Ray Stell | 2006-10-05 12:17:27 | Re: postgresql db account |