Please Help!

[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!

[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

[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.

[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

[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."

???

[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.

[bl33ch]

So how do i create a diff name database? I tried but it doesnt work.
Sorry not my thing this SQL.

[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?