Re: Newbie: FAQ - change root password?

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