On Tue, Oct 11, 2011 at 4:01 AM, nirodha <erikwinnm...@yahoo.com> wrote: > > The following bug has been logged online: > > Bug reference: 6251 > Logged by: nirodha > Email address: erikwinnm...@yahoo.com > PostgreSQL version: 8.4 > Operating system: ubuntu > Description: cannot create roles that can actually login > Details: > > I literally cut and paste the commands from the manual to create a role > after about two hours of repetition and reading .. yes, "with login" "with > login password 'foo'", whatever. Tried createuser - I have to be honest; 3 > hours later and I am ready to go back to MySQL. Documentation is sparse, > there is no forum on the site - I am a bit disappointed after all the hype > about how great postgres is .. 3 hours later and I cant even create a user > that can login! > Thanks.
Uh, well, I am pretty sure that this works, or else we would have a lot of unsatisfied users, but it's pretty much impossible to guess what you did wrong based on this amount of information. Showing us the exact command that you typed to create a user, and then the exact command that you typed to try to connect as that user, and then the exact error message that you got would help a lot. Just off the top of my head, a likely culprit is that you may need to adjust your pg_hba.conf file. http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
