Windows 7/ 64-bit system postgresql installation

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Windows 7/ 64-bit system postgresql installation

Postby Fany » Tue May 19, 2009 10:54 pm

Hi, i've been browsing this forum all day for a standard solution of installing postgres onto a windows 7 RC 64-bit system but it just gets so confusing with all these different answers.

3 versions of postgres seems to be compatible with vista/W7:
8.2.7 (recommended in the stickied thread)
8.2.13 (latest version of 8.2.x)
8.3.7 (the lastest version of 8.3.x seems to have fixed the compatibility issues with vista/ 64-bit machines?)
and
8.4.beta (some say this works with windows7?)

Which one should someone with windows 7 RC 64-bit use????

Thanks for looking. Hopefully answer will be below if you're in the same boat as I.

-Fany
Fany
 
Posts: 5
Joined: Tue May 19, 2009 10:33 pm

Re: Windows 7/ 64-bit system postgresql installation

Postby WhiteRider » Wed May 20, 2009 4:48 am

I haven't tried Windows 7 64-bit, but I have installed PT3 beta 27 and postgres 8.4 on Windows7 and it works fine.
You can get postgres 8.4 from this link.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Windows 7/ 64-bit system postgresql installation

Postby Fany » Thu May 21, 2009 5:49 pm

Thanks for your help. I got the installation done. For others in my situation, make sure you set your password to 'dbpass' when they ask you for it so PT3 can connect.

I now have another problem with the HUD and importing my old hands.
1. I cannot view my imported hands. I can see the amt won and loss for time and table, but i cannot see individual hands. Is there an FAQ for importing?
2. Even though the HUD is running (that PT icon on the table where you configure HUD stats), I cannot see individual player stats - They do not pop up.
3. I can getting this message in the log:

2009/05/21 17:35:37: Full Tilt: Loading hand history file: C:\Program Files (x86)\Full Tilt Poker\HandHistory\HELPMEHELPEME\FT20090521 Market Crest - $0.25-$0.50 - $15 Cap No Limit Hold'em.txt
2009/05/21 17:35:37: Full Tilt: Unable to import hand (#12353974174). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid input syntax for integer: "f" CONTEXT: COPY holdem_hand_player_statistics, line 1, column cnt_players: "f" )


I am using PT3 Build 4 instead of beta 27 if that matters.

Thank you for your help!! I will try to post my problems as detailed as possible so that others with Windows 7 can use PT3 as well.

-Fany

PS. Windows 7 is sexy.
Fany
 
Posts: 5
Joined: Tue May 19, 2009 10:33 pm

Re: Windows 7/ 64-bit system postgresql installation

Postby kraada » Fri May 22, 2009 9:19 am

It sounds like you're importing hands in Build 4 into a Beta 27 database. Try upgrading to Beta 27.1 and create a new clean database and use the manual import to reimport the hands you've previously imported (they'll be in C:\Program Files\PokerTracker 3\Processed) and see if that fixes things for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Windows 7/ 64-bit system postgresql installation

Postby qwertasyx » Tue Jun 09, 2009 7:38 am

hi, i wannt to install postgres 8.4 (W7 64bit), but after installing it says:
"Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed"

whats the problem here? under viste i must deactivate UAC, but i cant find it on W7..

and i cant connect with pt3 then.
qwertasyx
 
Posts: 3
Joined: Tue Jul 15, 2008 6:57 am

Re: Windows 7/ 64-bit system postgresql installation

Postby kraada » Tue Jun 09, 2009 9:00 am

You still need to disable UAC in Win7, see this post for a walkthrough on how to accomplish it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Windows 7/ 64-bit system postgresql installation

Postby qwertasyx » Tue Jun 09, 2009 9:59 am

ok i did... same error occours.. what else cann i do?
qwertasyx
 
Posts: 3
Joined: Tue Jul 15, 2008 6:57 am

Re: Windows 7/ 64-bit system postgresql installation

Postby kraada » Tue Jun 09, 2009 10:03 am

Try unchecking "Initialize Database Cluster" as explained in this tutorial (see page 16)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Windows 7/ 64-bit system postgresql installation

Postby qwertasyx » Tue Jun 09, 2009 10:26 am

i dont come that far.. i choose the language.. and next screen is the installprogress (and during this the error occurs)..
if i click ok it says its installed succesfully?!
qwertasyx
 
Posts: 3
Joined: Tue Jul 15, 2008 6:57 am

Re: Windows 7/ 64-bit system postgresql installation

Postby kraada » Tue Jun 09, 2009 10:45 am

Please create a support ticket using this link and include screenshots of where you see the error and we will help you get this resolved.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 19 guests

cron