Thread: forgotten password
Hello, I was learning how to use the Postgresql and using the Pgadmin, but I forgot the password. Then I tried to uninstall and reinstall it but it doesn't work, I still need the password to reinstall.
I think I don't have the file pg_hba.conf anymore. How should I proceed?
--
[]'s
Information is not knowledge
Knowledge is not wisdom
Wisdom is not beauty
Beauty is not love
Love is not music
Music is the best
[]'s
Information is not knowledge
Knowledge is not wisdom
Wisdom is not beauty
Beauty is not love
Love is not music
Music is the best
On 21/03/2012 14:27, Yamato Suemitsu wrote: > Hello, I was learning how to use the Postgresql and using the Pgadmin, > but I forgot the password. Then I tried to uninstall and reinstall it > but it doesn't work, I still need the password to reinstall. What platform(s) are you on? What is the 'it' that you reinstalled - PostgreSQL or pgAdmin? Which password have you forgotten - the password for the system account under which PostgreSQL runs, or the password to access the database server? > I think I don't have the file pg_hba.conf anymore. How should I proceed? It doesn't matter about pg_hba.conf - no passwords are stored there, it just sets access rules about who can connect, from where and how. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
On 22/03/2012 16:27, Yamato Suemitsu wrote: > Platform: Windows 7 Ultimate, x86 32 bit > I have reinstalled pgAdmin. > I forgot the password for the system account. In that case, you use the normal Windows tools to reset it. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie