PJ.,
> >su pgsql
> >psql database
> >ALTER USER username WITH PASSWORD password NOCREATEDB NOCREATEUSER
> >
> >There is no error message.
> >I do restart posgresql and then check on Webmin. It always shows the
> same configuration for the username: Requires password? No; Can
> create databases? No; Can create users? No; Valid until Forever.
> >I can delete the username and when I create a new one with same name
> but with new password, the result is the same. :((
> CORRECTION!!! (I forgot to finish the command with the semicolon ";"
> and I did not enter the password with single quotes)
> However, I just tried again:
Sounds like your problem is with pg_hba.conf, not ALTER USER. Wanna
post the non-commented portions of your pg_hba.conf file?
-Josh