Re: Newbie: FAQ - change root password?
От | Paul Thomas |
---|---|
Тема | Re: Newbie: FAQ - change root password? |
Дата | |
Msg-id | 20031117115704.A23437@bacon обсуждение исходный текст |
Ответ на | Newbie: FAQ - change root password? (Fajar Priyanto <fajarpri@arinet.org>) |
Список | pgsql-general |
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 | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: