Re: postgresql db account - Mailing list pgsql-novice

From Ray Stell
Subject Re: postgresql db account
Date
Msg-id 20061005121727.GB30988@cns.vt.edu
Whole thread Raw
In response to Re: postgresql db account  (Sean Davis <sdavis2@mail.nih.gov>)
Responses Re: postgresql db account  (Sean Davis <sdavis2@mail.nih.gov>)
Re: postgresql db account  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: postgresql db account
Next
From: Sean Davis
Date:
Subject: Re: postgresql db account