From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: default superuser |
Date: | 2007-12-28 17:59:28 |
Message-ID: | D7FF158337303A419CF4A183F48302D603867F31@hdsmsx411.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com]
Sent: Friday, December 28, 2007 12:26 PM
To: Gauthier, Dave
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-12-28 18:07:05 | Re: default superuser |
Previous Message | Joshua D. Drake | 2007-12-28 17:26:26 | Re: default superuser |