| From: | Ray Stell <stellr(at)cns(dot)vt(dot)edu> |
|---|---|
| To: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
| 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:17:27 |
| Message-ID: | 20061005121727.GB30988@cns.vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2006-10-05 12:21:04 | Re: postgresql db account |
| Previous Message | Sean Davis | 2006-10-05 12:06:06 | Re: postgresql db account |