Search Postgresql Archives

Re: resetting postgres password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Apr 6, 2005, at 8:22 AM, D A GERM wrote:

What is the easiest way to reset the postgres user password?

Using the ALTER USER command. If you don't know the password, temporarily modify the pg_hba.conf file to allow local connections without a password ('trust'). You can then login without the password and reset it.



John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL


---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux