PDA

View Full Version : initialization of database (SQL)



raver44
10-02-2009, 10:28 AM
Hi, I'm french and i'll try to translate correctly my problem with the installation of PostgresSQL.


During the installation of PostgresSQL, there is a mistake in the step "initialization of database".

This is the error :
"the notebook of specified databases is not empty
If you have already a database with the same number, you don't need to initialize a database group.
If you have a database with a number of a different type, you need to save your old database and create another one."

I never use HM before, how can I have a database before ? Idon't understand what's going on..
How can i deal with that ?

Thank you.

raver44
10-02-2009, 10:40 AM
I think now it's ok i found it! ty

raver44
10-06-2009, 11:08 AM
Arf.. i thought it was good but no it doesn't work, if someone can help me, ty.

raver44
10-06-2009, 12:01 PM
Now the problem is :

"The user account already exists".

fozzy71
10-06-2009, 12:05 PM
It sounds like you installed the trial of PT3 before?


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

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




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 doesnt help:


For uninstalling SQL please follow these steps:

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

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

raver44
10-08-2009, 02:05 PM
Ty for your help it's ok now :) !!