I think I created a cluster (initdb) and then a database (createdb mypgdb). I believe I am the default superuser (my linux uid). At least I appear to own everything using "psql -l". And I needn't identify myself when making a db connection through that user. I then created a user that I wanted to grant "all" to and that seemed to work... create user foo password 'foopass'; grant all on database mypgdb to foo; And I can connect using the "foo" user (psql -U foo mypgdb). But it doesn't seem to require the password. Would you know why? I would like to use the password protection. -dave -----Original Message----- From: Joshua D. Drake [mailto:jd@xxxxxxxxxxxxxxxxx] Sent: Friday, December 28, 2007 12:26 PM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: default superuser Gauthier, Dave wrote: > Hi > > > > I created a database instance and a database takign whatever defaults > were in effect with regard to defining a superuser and password. What > are those defaults? How do I change the password for the superuser? You created a database or a cluster? What command did you use? I suggest you look at: http://www.postgresql.org/docs/8.2/static/user-manag.html http://www.postgresql.org/docs/8.2/static/managing-databases.html http://www.postgresql.org/docs/8.2/static/client-authentication.html Sincerely, Joshau D. Drake > > Thanks > > -dave > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
