Page 1 of 1
Please Help!
Posted:
Wed Jan 30, 2008 2:56 am
by bl33ch
2008-01-30 01:12:34 STATEMENT: CREATE DATABASE "PT3 Beta DB1" WITH OWNER = Bogdan ENCODING = 'SQL_ASCII' TABLESPACE = pg_default;
2008-01-30 01:12:56 ERROR: role "bogdan" does not exist
This is after installation when I'm trying to create a Database.
Please help!
Re: Please Help!
Posted:
Wed Jan 30, 2008 3:16 am
by APerfect10
When you installed PostgreSQL and were prompted with the screen below, what "database user" did you enter? Did you change it from "postgres"?
[imgpqk]http://www.pokertracker3.com/templates/products/PT3/docs/images/configuring_postgresql.png[/imgpqk]
The username you entered above you identically match what is entered in the user field in the screenshot below:
[imgpqk]http://www.pokertracker3.com/templates/products/PT3/docs/images/configure_first_database.png[/imgpqk]
Best regards,
Derek
Re: Please Help!
Posted:
Wed Jan 30, 2008 3:23 am
by bl33ch
I did change it from postgres to Bogdan on both with same password.
I am using the same Bogdan password when i try to create.
Re: Please Help!
Posted:
Wed Jan 30, 2008 3:34 am
by APerfect10
Go Start->Run, "cmd" then OK.
Then paste the following into the command line to change your directory to the PostgreSQL bin directory:
[code83f]cd "C:\Program Files\PostgreSQL\8.2\bin"[/code83f]
Then paste:
[code83f]createdb -O Bogdan -h localhost -U Bogdan Bogdan[/code83f]
You will be prompted for your PostgreSQL password for "Bogdan". Type it then press enter. It should confirm that the database "Bogdan" was created.
Then proceed from where you were creating a new database in PT3.
Best regards,
Derek
Re: Please Help!
Posted:
Wed Jan 30, 2008 3:41 am
by bl33ch
Thank you for your help first of all.
I did just like you said: I created the database "Bogdan" in cmd but when I'm trying to log in to it from PT3 i get this message:
"Database 'Bogdan' is not a valid PokerTracker database."
???
Re: Please Help!
Posted:
Wed Jan 30, 2008 3:58 am
by APerfect10
[quote="bl33ch"4gl]Thank you for your help first of all.
I did just like you said: I created the database "Bogdan" in cmd but when I'm trying to log in to it from PT3 i get this message:
"Database 'Bogdan' is not a valid PokerTracker database."
???[/quote4gl]
You do not want the database name (database field) to be "Bogdan" since that is your username. You should name it something else.
Re: Please Help!
Posted:
Wed Jan 30, 2008 4:04 am
by bl33ch
So how do i create a diff name database? I tried but it doesnt work.
Sorry not my thing this SQL.
Re: Please Help!
Posted:
Wed Jan 30, 2008 4:11 am
by APerfect10
[quote="bl33ch"7wp]So how do i create a diff name database? I tried but it doesnt work.
Sorry not my thing this SQL.[/quote7wp]
What are you entering in all of the fields?