2

I have postgresql 9.2 installed on a windows XP machine. I have lost the postgres password.

I looked at answers given to a similar question asked 6 months ago. The answer given there required the editing of a file pg_hba.conf however I cannot find that file anywhere. Windows search doesn't find it.

I have tried uninstalling the postgreSQL installation but that seems to leave behind the password and security settings as on installing again the step to set the postgres password is missed out.

Help please?

András Váczi
  • 31,778
  • 13
  • 102
  • 151
nigellaw
  • 133
  • 1
  • 5

1 Answers1

1

Having previousley tried to delete PostgreSQL and reinstall it I realise I had neglected to delete the files the uninstall leaves behind. In a Windows XP environment these are found in C:/Program Files/PostgreSQL/9.2 Deleting the remaining files in the directory 9.2 and then deleting the directory PostgreSQL allowed me to perform a completely new install of PostgreSQL without any failures. Of course the new installation process requires input of new passwords, this time I made a note of them :)

nigellaw
  • 133
  • 1
  • 5