PDA

View Full Version : Porblems getting the database to work.



Fredron
07-18-2009, 05:11 PM
So I've installed the PostgresSQL and now installing the actual program.
I get an error saying that the user doesn't exist when I enter Login name and password.
Shouldn't that be postgresuser and postgrespass or have I misunderstood something?
I tried with all the different usernames I had in the postgres and password but none seemed to work.

fozzy71
07-18-2009, 09:06 PM
It should say that the user does not exist, and asks if you would like the installer to create the user for you.


http://www.holdemmanager.net/faq/files/Image/postgrePassNewUser.jpg

Fredron
07-19-2009, 05:03 AM
I have uploaded a picture so you can see what the problem is yourself. The error messages don't come at once it's first when I try postgres and then postgresuser.

http://img195.imageshack.us/i/probs.png/

netsrak
07-19-2009, 06:22 AM
Which user did you create during the installation?
postgres or postgresuser? You must choose the right one.

To find it out: start pgadmin, connect to your database server and look at the bottom which role is defined. This is the name you have to use.

Fredron
07-19-2009, 06:40 AM
Which user did you create during the installation?
postgres or postgresuser? You must choose the right one.

To find it out: start pgadmin, connect to your database server and look at the bottom which role is defined. This is the name you have to use.

Aight I found out what the username was and I used that instead, got past that step and now to create a new database. Suddenly it says " Error 42307: role Fredron does not exist"

netsrak
07-19-2009, 08:11 AM
I suggest you make a complete postgres deinstallation and reinstall it using the settings from the installation guide.

Make sure you delete the postgres (and postgresuser) user account after uninstalling:
- run the command - start > run > cmd >
net user postgres /delete
- reboot.

It seems there is something wrong with your userroles. You should create a user postgres not Fredron or something else.

Installation guide:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176

Fredron
07-19-2009, 09:57 AM
Thank you two, I think I got it all working now so gonna try to find out how the features work :)