PDA

View Full Version : Problem installing Postgres.



Xaider
08-26-2009, 12:15 PM
I have some trouble installing postgres. I mainly get the error "User account already ecsist" I tried different "solutions" Older postgres, deleting folders, rebooting. I heard from a friend that a technician might do the installing for you or smthing. ;D I have no clue.

fozzy71
08-26-2009, 12:46 PM
If you created a unique name and password during install, you will need to enter that now.

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

svcpass is another possibility


Go to your command function (for Vista users, type cmd in search) and type net user. This will show you which user groups are on your pc.

Net user will tell you what the user is on your machine.

If you still can't get connected thru HM you can either try to remove the password requirement entirely.


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



If that doesn't work, you will probably need to do a reinstall of postgresql and pay close attention to the instructions and make sure you write down any user names and passwords to be sure.


Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall, using these directions and postgresql.zip version. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176