Thread: Newbie: FAQ - change root password?
-----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-----
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
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 >
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 | +------------------------------+---------------------------------------------+