PDA

View Full Version : "user name already exists" postgre problem



jiggajake
08-19-2009, 05:20 PM
i tried posting in the postgre forum but nobody responded....

i had it all up and working and then i had to reinstall my HEM and now it asks for a password for my Postgre, i never set one so idk what it is....


upon this i decided to try and uninstall/delete postgre and reinstall it. Now it is completely off my computer (i think) i deleted the shit in the program files and i uninstalled it from the control panel.

I tried to do the net user postgre/delete in the cmd prompt, but all it says is :

[password : *] [options]] [/domain]
and about 3 more lines of basically the same thing

any help would be greatly appreciated as i cant use my HEM with out this :(

fozzy71
08-19-2009, 09:23 PM
You entered tbhe command exactly like this:


net user postgres /delete

If yes, and that's the error you received, my suggestion would be to reinstall postgresql but use a different user name, such as:

postgresuser or postgreshm





For your information, in case you need to know in the future:

PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass


If that password isn't right, you can try using svcpass, or postgrespass.


If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.

Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5


You need to change the first 'md5' to 'trust', like this




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5



Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration

jiggajake
08-20-2009, 12:42 AM
thanks so much man, the svcpass was the money spot......i owe you my life