Page 1 of 1

Postgres sql update or not?

PostPosted: Tue Apr 22, 2025 1:02 pm
by raverlof666
When I open pgAdmin 4, i have this message

You are currently running version 7.2 of pgAdmin 4, however the current version is 9.0
Please click here for more information.
https://www.enterprisedb.com/downloads/ ... -downloads

once I click, i have version of PostgresSQL from 13.20 up to 17.4 .

I just want to make sure, since my PT4 ddbb and everything is working smooth and good, if it is worth it to update ? Will it improve anything? Will I run the risk to screw my ddbb if I update to the latest?? What would support recomend me ?


thanks for your help and time.
much appreciate it.

Re: Postgres sql update or not?

PostPosted: Wed Apr 23, 2025 6:45 am
by Flag_Hippo
What version of PostgreSQL (NOT the version of PGAdmin) are you currently using?

Re: Postgres sql update or not?

PostPosted: Wed Apr 23, 2025 9:14 pm
by raverlof666
how do I check the postgressql versioN? I can't find it

Re: Postgres sql update or not?

PostPosted: Wed Apr 23, 2025 9:16 pm
by raverlof666
once I open PGADMIN 4
down below servers, I see PostgresSQL 12 that opens the databases (5) trees

Re: Postgres sql update or not?

PostPosted: Thu Apr 24, 2025 6:23 am
by Flag_Hippo
If you were using an older version of PostgreSQL I would recommend upgrading but if you are using PostgreSQL v12 and everything is working fine then you can continue using that. PokerTracker v4.18 did add support for PostgreSQL v16 if you do want to upgrade and we have a guide for that here:

Guide: How to manually update PostgreSQL

Re: Postgres sql update or not?

PostPosted: Thu Apr 24, 2025 11:12 am
by raverlof666
but are there any advantages on it??

Re: Postgres sql update or not?

PostPosted: Thu Apr 24, 2025 12:18 pm
by Flag_Hippo
PostgreSQL v16 will have database performance improvements when compared to earlier versions. If you want to compare performance between the two in your case you can do a separate install of PostgreSQL v16 while keeping your existing v12 install & data.