Unable to create PostgreSQL database

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

Unable to create PostgreSQL database

Postby Superedo » Sat Feb 18, 2012 11:40 am

Hello,
I've just installed the pokertracker 3 trial version, but when i try to connect, this message appears to me: http://i39.tinypic.com/34xl6p5.jpg

and if i click ok:
http://i42.tinypic.com/1e9iqx.jpg

but i'm sure i've enabled the firewall already.
Please, help me!!

ps sorry for my bad english.
Superedo
 
Posts: 3
Joined: Sat Feb 18, 2012 11:32 am

Re: Unable to create PostgreSQL database

Postby WhiteRider » Sat Feb 18, 2012 1:02 pm

That's strange - please run PT3 using the 'Logging Enabled' option in the Start menu and when you get the error attach the PokerTracker.log to a Support Ticket so that we can see what is going on.

Tutorial: Submitting a Bug Report
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to create PostgreSQL database

Postby Superedo » Sat Feb 18, 2012 1:43 pm

Could it be this the log file? sorry but i'm such a noob with this :D
Spoiler: show
2012/02/18 18:41:30.750: [- Main -][System] PokerTracker v3.11.10 beta
2012/02/18 18:41:30.780: [- Main -][SystemInfo] OS: Windows XP (build 2600, Service Pack 3)
2012/02/18 18:41:30.790: [- Main -][SystemInfo] Windows Version: 5.1 build 2600 (platform 2) Service Pack 3
2012/02/18 18:41:30.800: [- Main -][SystemInfo] Current Code Page: 1252 Locale: 0410
2012/02/18 18:41:30.810: [- Main -][SystemInfo] Total Logical Processing Units: 1
2012/02/18 18:41:30.820: [- Main -][SystemInfo] Processor Info: Numa: 1 Pkg: 1 Cores: 1 PUs: 1 (L1: 0, L2: 0, L3: 0)
2012/02/18 18:41:30.820: [- Main -][SystemInfo] Processor 1: Speed: 2.39 GHz Name: Intel(R) Pentium(R) 4 CPU 2.40GHz
2012/02/18 18:41:30.830: [- Main -][SystemInfo] C:\ Disk Space: 76,309 mb total; 37,599 mb used; 38,710 mb free
2012/02/18 18:41:30.850: [- Main -][SystemInfo] Physical Memory: 479 mb (261 mb available) Virtual Memory: 2,048 mb (1,973 mb available) Page File: 1,122 mb (774 mb available)
2012/02/18 18:41:30.890: [- Main -][System Info] Video[0]: S3 Graphics ProSavageDDR (\\.\DISPLAY1)
2012/02/18 18:41:30.900: [- Main -][SystemInfo] Adobe Flash: 10.1.82.76 Plugin: 10.1.82.76 AIR: 3.1.0.4880
2012/02/18 18:41:30.910: [- Main -][SystemInfo] Configuration: [WindowInfo]\n\n\n[General]\nLogging=N\nBuildDate=2012/02/17\n\n\n[Import]\nBeepOnCompletion=Y\nClusterOnCompletion=Y\nVacuumOnCompletion=Y\nAnalyzeOnCompletion=Y\nUpCacheOnCompletion=Y\n\n\n\n[Database]\nDefault.Postgres.Port=0\n\n\n[ReportInfo]\n\n\n[HandReplayer]\n\n[Messages]\nOptOut:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\n
2012/02/18 18:41:31.041: [- Main -][System] Getting String: 105A-4E4B-5E3C-9DA0-84B7-4CC6-3C0D-14F9
2012/02/18 18:41:31.081: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2012/02/18 18:41:31.111: [- Main -][wxThreadedRead] Starting read thread ...
2012/02/18 18:41:31.121: [00000C1C][ConnectorReadThread] Thread [0x00000C1C]: Begin
2012/02/18 18:41:31.121: [00000C1C][ConnectorReadThread::Entry] Beginning thread.
2012/02/18 18:41:31.131: [00000C1C][ConnectorReadThread] Creating socket...
2012/02/18 18:41:31.141: [00000C1C][ConnectorReadThread] DNS lookup...
2012/02/18 18:41:31.151: [00000C1C][ConnectorReadThread] Socket connect...
2012/02/18 18:41:31.912: [00000C1C][ConnectorReadThread] Sending request...
2012/02/18 18:41:32.252: [00000C1C][ConnectorReadThread] Reading response...
2012/02/18 18:41:32.272: [00000C1C][ConnectorReadThread] Read complete.
2012/02/18 18:41:32.312: [00000C1C][ConnectorReadThread] Returning.
2012/02/18 18:41:32.392: [- Main -][wxThreadedRead] Getting data ...
2012/02/18 18:41:32.402: [- Main -][Registration] License written to C:\Programmi\PokerTracker 3/Data/Config/PokerTracker.lic
2012/02/18 18:41:32.443: [- Main -][System] Registered: false
2012/02/18 18:41:32.453: [- Main -][System] HelpMessages v1.01 is up to date.
2012/02/18 18:41:32.453: [- Main -][System] FullTilt v1.15 is up to date.
2012/02/18 18:41:32.463: [- Main -][System] 888 v1.1 is up to date.
2012/02/18 18:41:32.473: [- Main -][System] Currencies v1.01 is up to date.
2012/02/18 18:41:32.513: [- Main -][System] TournamentDetect v1.79 is up to date.
2012/02/18 18:41:32.543: [- Main -][System] Registration Status Invalid
2012/02/18 18:41:32.563: [- Main -][System] TRP Status: TH: true; TO: false; RH: false; RO: false; PH: true; PO: false;
2012/02/18 18:41:41.486: [- Main -][WindowSplash] Beginning load process
2012/02/18 18:41:42.747: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/18 18:41:42.817: [- Main -][PostgresConnection] [0012EAD8] Successfully connected to: postgres [0x033c5370] (ver = 80410, autotune = Y)
2012/02/18 18:41:42.848: [- Main -][PostgresConnection] [0012EAD8] Disconnecting from database: postgres
2012/02/18 18:41:42.908: [- Main -][PostgresConnection] Connecting to database: PT3 DB
2012/02/18 18:41:42.988: [- Main -][PostgresConnection (Error)] Unable to login to database (PT3 DB). Reason: FATAL: database "PT3 DB" does not exist
2012/02/18 18:41:43.549: [- Main -][PostgresConnection] Connecting to database: PT3 DB
2012/02/18 18:41:43.619: [- Main -][PostgresConnection (Error)] Unable to login to database (PT3 DB). Reason: FATAL: database "PT3 DB" does not exist
2012/02/18 18:41:43.639: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/18 18:41:43.699: [- Main -][PostgresConnection] [0012F3F0] Successfully connected to: postgres [0x033c4dd0] (ver = 80410, autotune = Y)
2012/02/18 18:41:49.056: [- Main -][PostgresConnection] Connecting to database: PT3 DB
2012/02/18 18:41:49.137: [- Main -][PostgresConnection] [0012F240] Successfully connected to: PT3 DB [0x033c4550] (ver = 80410, autotune = Y)
2012/02/18 18:41:49.157: [- Main -][wxWidgets] Error: can't open file 'C:\Programmi\PokerTracker 3/Data/Schemas/schema.postgres.sql' (error 2: impossibile trovare il file specificato.)
2012/02/18 18:41:49.157: [- Main -][PostgresConnection (Error)] Unable to execute query: ; Reason: Empty Query ()
2012/02/18 18:41:49.167: [- Main -][PostgresConnection] [0012F240] Disconnecting from database: PT3 DB
2012/02/18 18:41:49.347: [- Main -][PostgresConnection] [0012F3F0] Disconnecting from database: postgres
Superedo
 
Posts: 3
Joined: Sat Feb 18, 2012 11:32 am

Re: Unable to create PostgreSQL database

Postby WhiteRider » Sat Feb 18, 2012 5:47 pm

Thanks - you got the right file.
It looks as if something is missing in your PT3 installation - please try running the PT3 installer again and if that doesn't help then open a Support Ticket with a link to this thread and one of our support technicians will work with you to get things working correctly.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to create PostgreSQL database

Postby Superedo » Sun Feb 19, 2012 6:47 am

I ran the setup again, and now it works correctly. thank you for the moment :D
Superedo
 
Posts: 3
Joined: Sat Feb 18, 2012 11:32 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests

cron