From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | pippo(at)bellnet(dot)ca, pgsql-novice(at)postgresql(dot)org |
Cc: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Subject: | Re: ALTER USER does not work |
Date: | 2003-01-11 00:03:42 |
Message-ID: | web-2310405@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Babu Khan | 2003-01-11 00:43:17 | Install postgres 7.2 on Mac problems |
Previous Message | pippo | 2003-01-10 23:09:53 | Re: ALTER USER does not work |