Re: [general] Permissions - Mailing list pgsql-general

From Travis Bauer
Subject Re: [general] Permissions
Date
Msg-id 200111122316.fACNGt608214@whale.cs.indiana.edu
Whole thread Raw
In response to Re: [general] Permissions  (Jeff Davis <list-pgsql-general@dynworks.com>)
Responses Re: [general] Permissions
Re: [general] Permissions
List pgsql-general
Thank you.  This worked.  In testing it out, I noticed that postgres only
considers the first eight charaters of the password.  So

abcdefghijklm
abcdefghmlkji

are considered the same by postgres.  Is that correct?

Travis

On Monday 12 November 2001 01:01, Jeff Davis enlightened me by saying:
> PostgreSQL has, it seems, a somewhat weak permissions system, although it
> definately gets the job done.
>
> What you can do is have a seperate pg_hba.conf entry for every
> user/database combination you would like to be able to connect. To make
> this work, make a seperate password file for each user using pg_passwd.
> Lets say you call two files a_passwd and b_passwd (in accordance with your
> example), then make the lines:
>
 . . .

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 7.0.2 -> 7.1 performance drop
Next
From: Doug McNaught
Date:
Subject: Re: 7.0.2 -> 7.1 performance drop