[GENERAL] default superuser
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: [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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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:[EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] default superuser
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 28 Dec 2007 12:59:28 -0500 Gauthier, Dave [EMAIL PROTECTED] 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- ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster