what is the password for the postgresql connection

[caneilan]

what is the password for the postgresql connection? I accidently removed it and now I need to reenter it to use pt2.

Thank you

[ptrack pat]

You would have entered that password when you installed PostgreSQL so I don't know what it is. Go to the Start > Programs > PostgreSQL > Configuration Files > Edit pg_hba.conf

At the bottom, replace both places where it says "md5" to say "trust" and save. Then you can enter whatever password you want into the PostgreSQL settings field and it won't give an error.

[caneilan]

Pat:

Thank you for taking the time to answer my questions. I have another problem though. When I enter the word trust and then go to save the file it says (save as) "files\postgresql\8.2\data\pg_hba.conf file. make sure that path and file name are correct" Then it goes to another screen that says "saves as" and then it says do u want to replace it because it already exists, if i hit yes it goes back to the first prompt, its just a circle. What am i doing wrong here and can you help me out?

[ptrack pat]

Are you using Vista? If so, you need to right-click on "Edit pg_hba.conf" on the menu and select "Run as administrator" in order to edit it.

[gediminas]

start > administrative tools > computer management > system tools > local users and groups > users

rightclick on postgres > set password > proceed > enter new password > ok

restart setup.

good luck.

[ptrack pat]

start > administrative tools > computer management > system tools > local users and groups > users

rightclick on postgres > set password > proceed > enter new password > ok

restart setup.

good luck.

This is for changing the user that starts the PostgreSQL service when you start your computer, it doesn't have anything to do with the database user/passoword and isn't what this user needs to do.