Thread: Newbie: FAQ - change root password?

Newbie: FAQ - change root password?

From
Fajar Priyanto
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Dear all,
Thanks. I can now running psql in tcp mode. However, I'm really new with psql.
I've searched the FAQ, and found nothing on how to change root password of
psql.
I've also browsed the Admin Guide, but on the user management section, it
seems to assume that we're already know how to connect to it as root user,
but not how to setup the root user.

Is there any similarity with mysql command:
mysqladmin -u root password password to change the password?
Thanks
- --
Fajar http://linux.arinet.org
Linux mdk91.sistek.kom 2.4.21-0.13mdk GNU/Linux
17:25:39 up 9:36, 10 users, load average: 0.47, 0.61, 0.59
Quote of the day:
Win98 error 007: Fatal error: unforseeable condition: Your system has booted
without crashing. Shutting down to compensate.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/uKLuMai9kCFqACoRAmIeAKDI+0MFnc9+OFe84riHKRdvevezoACgmuPr
hBx5IvsvONFLT5Md4pJCXvc=
=RQrj
-----END PGP SIGNATURE-----


Re: Newbie: FAQ - change root password?

From
Peter Eisentraut
Date:
Fajar Priyanto writes:

> Thanks. I can now running psql in tcp mode. However, I'm really new with psql.
> I've searched the FAQ, and found nothing on how to change root password of
> psql.

There is no such thing as a root password for psql.  In the default setup,
you can connect to the database without any password, so unless you
changed something, then you don't need to worry about that until later.
(Where "later" means, when you devise an access control system for your
publically accessible database server.)

--
Peter Eisentraut   peter_e@gmx.net


Re: Newbie: FAQ - change root password?

From
"Brett Maton"
Date:
Hi Fajar,

  The only user setup by default is "postgres",  you need to add additional
users using the command line tool
  createuser, or from within psql using the sql command create user

HTH

Brett

"Fajar Priyanto" <fajarpri@arinet.org> wrote in message
news:200311171729.03757@say.no.to.microsoft...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dear all,
> Thanks. I can now running psql in tcp mode. However, I'm really new with
psql.
> I've searched the FAQ, and found nothing on how to change root password of
> psql.
> I've also browsed the Admin Guide, but on the user management section, it
> seems to assume that we're already know how to connect to it as root user,
> but not how to setup the root user.
>
> Is there any similarity with mysql command:
> mysqladmin -u root password password to change the password?
> Thanks
> - --
> Fajar http://linux.arinet.org
> Linux mdk91.sistek.kom 2.4.21-0.13mdk GNU/Linux
> 17:25:39 up 9:36, 10 users, load average: 0.47, 0.61, 0.59
> Quote of the day:
> Win98 error 007: Fatal error: unforseeable condition: Your system has
booted
> without crashing. Shutting down to compensate.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQE/uKLuMai9kCFqACoRAmIeAKDI+0MFnc9+OFe84riHKRdvevezoACgmuPr
> hBx5IvsvONFLT5Md4pJCXvc=
> =RQrj
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>



Re: Newbie: FAQ - change root password?

From
Paul Thomas
Date:
On 17/11/2003 10:29 Fajar Priyanto wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dear all,
> Thanks. I can now running psql in tcp mode. However, I'm really new with
> psql.
> I've searched the FAQ, and found nothing on how to change root password
> of
> psql.
> I've also browsed the Admin Guide, but on the user management section, it
>
> seems to assume that we're already know how to connect to it as root
> user,
> but not how to setup the root user.
>
> Is there any similarity with mysql command:
> mysqladmin -u root password password to change the password?


That's for MySQL. PostgreSQL is completely different. The equivalent to
the MySQL root user is the postgres super-user. su to postgres, then do
psql template1 and use SQL to change the password.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+