Re: [GENERAL] default superuser

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@commandprompt.com] Sent: Friday, December 28, 2007 12:26 PM To: Gauthier, Dave
Cc: pgsql-general@postgresql.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?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

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.htmlhttp://www.postgresql.org/docs/8.2/static/managing-databases.htmlhttp://www.postgresql.org/docs/8.2/static/client-authentication.html

Sincerely,

Joshau D. Drake

>
> Thanks
>
> -dave
>

---------------------------(end of broadcast)---------------------------