errors trying to convert my pt hold-em to postgre

[CarpeDiem]

Hi,

I'm trying to convert my access files to Postgre & when I try to start conversion I get this:

***********
Error connecting to the default postgresql database:

101 - squltate = 08001
fatal: password authentication...

This could be...

************

I don't even remember entering a password for this...

Is there a way to change this password?

Thanks!

[ptrack pat]

You had to have entered a password when you installed PostgreSQL. You were supposed to write it down.

[quote00v]fatal: password authentication...[/quote00v]
'
What is the rest of the sentence?

What email was used to purchase Poker Tracker? I have no record of this one used for the forum.

[CarpeDiem]

Sorry Pat...

The error code continues...

This could be because you have ....
1. Entered the wrong user name/password/server name/port.
1. not started the postgresql database server
3. not installed the postgre sql odbc driver.

Please click the help link at the top right corner ...

Here are my postgre sql settings

port server username password odbc entry to use encoding
5432 localhost postgres ********** postgresql unicode unicode

I will pm you my e-mail address....I have purchase 2 copies of pt 2 and intend to purchase pt 3...great product...

I have no clue on the password...but, I can narrow down the password possibilities online...if do I de-install & reinstall postgre or go forward?

Best to all your endeavors,

Paul

[ptrack pat]

Go to the Start menu and select Programs > PostgreSQL 8.2 > Configuration Files > Edit pg_hba.conf

At the bottom of this file are 2 places where it says "MD5", change these to be "trust" and then save the file and close it.

Then it won't matter if the password is wrong.

[CarpeDiem]

Pat,

The conversions went ok. Now, when I start PT & auto-import I get the following error:

A database error has occurred.

DBcode: =1003 Error TExt: sqlstate = S1093
[microsoft][odbc Microsoft Access Driver] Invalid Argument.

No changes made to database

Insert INTO players ( screen _name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ('Thight_RJ', 1, 41640, 2, 0, 1, 0 )

This error message was written into the error file: ....pterrorlog.text please send this file AND THE HAND history file that caused the error to support.... to diagnose.

It got me an endless loop where

Insert INTO players ( screen _name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ('[bbyo]loose_dude[/bbyo], 1, 41640, 2, 0, 1, 0 )

then

Insert INTO players ( screen _name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ('[bbyo]player dude[/bbyo]', 1, 41640, 2, 0, 1, 0 )

then

Insert INTO players ( screen _name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ('[bbyo]other guy[/bbyo]', 1, 41640, 2, 0, 1, 0 )

etc occurred

I ctl-alt-del'd out...

Suggestions?

[ptrack pat]

These are Access errors still which means you didn't do all of the steps in the "After PostgreSQL is installed" section here:
http://www.pokertracker3.com/products/P ... InstallSQL