Re: Newbie: FAQ - change root password?

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(at)arinet(dot)org> wrote in message
news:200311171729(dot)03757(at)say(dot)no(dot)to(dot)microsoft(dot)(dot)(dot)
> -----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
>