Re: Roles and passwds

"Birchall, Austen" <austen.birchall@metoffice.gov.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