PT4 error message

[uberslug]

Getting the following error message


pt4 unable to login to database (postgres). reason: could not connect to server


problems seemed to start when I change TZ on my laptop then tried to do the same for pt4. Have reverted back to old TZ on both but havent had any luck so far.

I tried to restart postgres but get the following error message

https://gyazo.com/09895370655962d73b8a1668b34688fb

[uberslug]

Just tried uninstalling Postgres and re installed it.

now get this error message

https://gyazo.com/a29eeb90536dc39ebe95a3b30734c8df

[WhiteRider]

When you re-installed PostgreSQL did you use the default port number (5432) and password (dbpass)?
If not, then you can edit the PokerTracker.cfg file to tell PT4 your new PostgreSQL server details.
To do that go to File > Open User Data Folder in the pt4 menu then close PT4 down.
In the window that opened go to the Config folder.
Open PokerTracker.cfg in Notepad.
Find the section labelled:
[Database]
..and update "Default.Postgres.Port" and "Default.Postgres.Password" to the values you used during the installation.
Save the file, then run PT4 again and you should now be able to create a new database.

[uberslug]

I did use the default port number and also the default password.

I am now getting this error message

https://gyazo.com/85a66330596439c5ed726530c8ea8424

Please note I am downloaded postgreSQL v9.6.16 as when I wanted to re install it I could not see 9.3 on the list to download.

also get this error message when I exit.

https://gyazo.com/d0accb1ae1e95b337756744a8f6b8749

[WhiteRider]

A different major version of PostgreSQL will not be able to read your old database. If you have a Backup you will be able to restore that, but otherwise you will either need to create a new database and re-import your hands, or (assuming that you didn't delete the old PostgreSQL data folder) you can re-install PostgreSQL 9.3 and that should be able to reconnect to your old database.

9.3 is available to download here (be sure to pick the correct version for your operating system).

[uberslug]

A different major version of PostgreSQL will not be able to read your old database. If you have a Backup you will be able to restore that, but otherwise you will either need to create a new database and re-import your hands, or (assuming that you didn't delete the old PostgreSQL data folder) you can re-install PostgreSQL 9.3 and that should be able to reconnect to your old database.

9.3 is available to download here (be sure to pick the correct version for your operating system).

I have downloaded 9.3 but to no avail. I receive this error message when trying to load up PT4 now

https://gyazo.com/39c7a7cac0776d0fd40af474ada2fc1b

I tried to connect https://gyazo.com/364147b6811f5d7bfaffe88f9bac322a

and get this error message when that says I can connect to the data base

https://gyazo.com/7ed533a8f75b153bbe5f27b7d849e9fb

Also received this error message https://gyazo.com/ec4f92e4499466626d989e605dc123fe

[Flag_Hippo]

PostgreSQL v9.3 hasn't installed correctly - please refer to the reply I gave you here.