| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Roles and passwds |
| Date: | 2013-03-19 13:57:47 |
| Message-ID: | 3205.1363701467@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
"Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> writes:
> I created the following role
> postgres=# create role sde LOGIN PASSWORD 'passwd' SUPERUSER NOINHERIT CREATEDB;
> [ but the password isn't used ]
> Is this expected behaviour?
It can be depending on how you have the server's authentication
configured (pg_hba.conf). A password will only be used if the server is
configured to demand one for the particular connection attempt. I
suspect you've got yours set to "trust" for local connections. Read
http://www.postgresql.org/docs/8.4/static/client-authentication.html
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Chong | 2013-03-19 19:57:36 | Question about error handling with UDF written in C |
| Previous Message | Birchall, Austen | 2013-03-19 11:39:30 | Roles and passwds |