"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