PokerTracker 4 Unable to Connect to Google Cloud SQL Postgre

[mura5726]

Hello,

I am currently trying to connect PokerTracker 4 to a PostgreSQL database (version 16) hosted on Google Cloud Platform, but I keep encountering an error that prevents me from establishing a connection.

The following error message appears:

>Unable to connect to PostgreSQL database: pokertracker4. Reason: This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.

What I have tried so far:

1. Allowed all IP addresses (0.0.0.0/0) in the Cloud SQL firewall settings.
2. Enabled public IP connectivity for the PostgreSQL instance.
3. Confirmed network connectivity from my local machine to the Cloud SQL instance (Test-NetConnection succeeded).
4. Double-checked the host name, username, password, and port number in PT4's database configuration screen.
5. Disabled SSL connections (both on Cloud SQL and PT4 sides).

The network connection appears to be working correctly, but the connection attempt from PT4 is still being refused. Could anyone provide some insight or potential solutions for this issue?

Thank you in advance for your help!

[Flag_Hippo]

Please note that PokerTracker 4 was not developed to support remote database access however if you attach your PokerTracker4.log file to a Support Ticket ticket we can see if we can offer any further assistance on that:

C:\Users\{Windows Login}\AppData\Local\PokerTracker 4\Logs\PokerTracker4.log

Guide: PokerTracker 4 Log Files

[mura5726]

Hello Flag_Hippo,

Thank you for your response.

As suggested, I have attached the log file (the contents below are from the latest connection attempt):

>2024/10/09 18:37:23.339 [01346]: [- Main -][WindowDialog] Opening Dialog: Configure PostgreSQL Database [WindowDialog::wdDatabasePostgres] (0019E640)
>2024/10/09 18:40:13.290 [99999]: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
>2024/10/09 18:40:13.290 [00000]: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
>2024/10/09 18:40:13.354 [00064]: [- Main -][WindowDialog] Opening Dialog: PostgreSQL Database Error [WindowDialog::WindowDialogMessage] (0019D288)
>2024/10/09 18:40:15.801 [02447]: [- Main -][WindowDialog] Closing Dialog: PostgreSQL Database Error (0019D288)
>2024/10/09 18:40:17.031 [01230]: [- Main -][WindowDialog] Closing Dialog: Configure PostgreSQL Database (0019E640)

Additionally, I tested the connectivity to the Google Cloud SQL instance using PowerShell, and it appears that the TCP connection was successful, as shown below:

>PS C:\Users\mura5> Test-NetConnection -ComputerName {Cloud SQL IP Address} -Port 5432
>
>ComputerName : {Cloud SQL IP Address}
>RemoteAddress : {Cloud SQL IP Address}
>RemotePort : 5432
>InterfaceAlias : Wi-Fi
>SourceAddress : 100.64.1.232
>TcpTestSucceeded : True

This indicates that the network connection itself is fine, but the connection attempt from PT4 is still being refused.

Could you please let me know if there are any additional settings or configurations I should check?

Thank you for your assistance.

[Flag_Hippo]

Unfortunately PokerTracker 4 was not developed to support remote database access and your setup is not something I am familiar with. As per my previous reply please attach your log file to a Support Ticket ticket and we can see if we can offer any further assistance on this.