Thread: default superuser

default superuser

From
"Gauthier, Dave"
Date:

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?

Thanks

-dave

Re: default superuser

From
"Joshua D. Drake"
Date:
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
>


Re: default superuser

From
"Gauthier, Dave"
Date:
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?

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
>


Re: default superuser

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 28 Dec 2007 12:59:28 -0500
"Gauthier, Dave" <dave.gauthier@intel.com> wrote:


> 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.

The problem is that you don't have your authentication configured. That
is discussed in detail here:

http://www.postgresql.org/docs/8.2/static/client-authentication.html

Sincerely,

Joshua D. Drake


- -- 
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ 
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHdTtMATb/zqfZUUQRAjFuAJ9T0xM7K4vAbrtqw3ZzFW8BVngZzQCfUgZH
/mG3+TfqT/8eK1MGwkU4E4E=
=pZgy
-----END PGP SIGNATURE-----