Upgrading postgresql from 8.3.0 to 9.x.y

[LillaPe]

Hi all

Just today I upgraded PT from V3 to v4. Since beginning of working with PT I never made an upgrade of the postgresql. So in PT it shows me that I'm working with v 8.3.0 yet. Seems to be time to get a upgrade here too.

1) What version is recommended to PT in this days?
2) How long it appr. will take until it is usefull to take the version 9.2?
3) Is there a thread or a link, which will be updatet regularly to see, which version of postgresql is recommended actually?
4) Which links are usefull to read before I'm going to work for the upgrade?

best regards
Pelle

[kraada]

(1) We recommend the latest minor version of 8.3, 8.4 or 9.0 (8.3.20, 8.4.13 or 9.0.9, respectively), though if you have a 64 bit machine, 9.0.9-x64 will be the best for you.

(2) I can't say at this point in time - there are still known data corruption and crashing issues in 9.1; we will investigate 9.2 and when we can confirm it does not cause problems we will announce it.

(3) Staying on the latest minor version of 8.3, 8.4 or 9.0 will always be fine - the minor version increases are always security updates.

(4) If you're starting fresh with PT4 the easiest thing to do is to install 9.0 and leave 8.3 installed (use a different port for 9.0) then use the PT3 -> PT4 conversion tool and that will convert everything into PT4's 9.0. Once you're satisfied that everything works you can remove 8.3.0 at your leisure.

[LillaPe]

Hi Kraada

So I was wrong to start with PT3->4 conversion based on the old database v 8.3.0 this afternoon.
Doesn't matter. Now I downloadet the Installation-file for postgresql 9.0.9 for winx86.

I'm hanging now on setup at the point for password: there is no way with "dbpass".
I got it from here: https://www.pokertracker.com/guides/PT4 ... 90-windows

Some other ideas?

Pelle

[LillaPe]

Was also trying:

"postgrespass" and "svcPASS83", which I found on other links in this forum - allways without ""!

but no success

[kraada]

Those are the only defaults that we use - is there some other password you might have used? The only other option is to delete the user and recreate it as explained in our uninstall and reinstall directions here.

[LillaPe]

So should I follow this link https://www.pokertracker.com/guides/PT4 ... 83-windows for the old version first?

Think that with this way I don't mess up things.
Is it possible afterwards to work again with old PT3 and postgresql 8.3.x?

Btw. I never changed any passwords in this case and also there is no other application on my computer using this database I guess. Could I find out by starting C:\Programme\PostgreSQL\8.3\bin\pgAdmin3.exe?
I got a screenshot attached...

And then there is another thing:
I found the following text in the file C:\Programme\PokerTracker 3\Data\Config\PokerTracker.cfg what also shows me that the password should be "dbpass" yet!!!

[Database]
Default.Postgres.Server=localhost
Default.Postgres.Port=5432
Default.Postgres.User=postgres
Default.Postgres.Password=dbpass
DB1.Name=PokerTracker 3 Beta Database PM01
DB1.Type=postgres
DB1.Postgres.Database=PT3 Beta DB1
DB1.Postgres.Server=localhost
DB1.Postgres.Port=5432
DB1.Postgres.User=postgres
DB1.Postgres.Password=dbpass
DB2.Name=PT3_2008_02_24_035952-Observed
DB2.Type=postgres
DB2.Postgres.Database=PT3_2008_02_24_035952
DB2.Postgres.Server=localhost
DB2.Postgres.Port=5432
DB2.Postgres.User=postgres
DB2.Postgres.Password=dbpass
DB3.Name=PokerTracker 3 Beta 10 Database PM02
DB3.Type=postgres
DB3.Postgres.Database=PT3_2008_05_05_100200
DB3.Postgres.Server=localhost
DB3.Postgres.Port=5432
DB3.Postgres.User=postgres
DB3.Postgres.Password=dbpass
DB4.Name=PokerTracker 3 Beta 10 Database PM03
DB4.Type=postgres
DB4.Postgres.Database=PT3_2008_05_05_145520
DB4.Postgres.Server=localhost
DB4.Postgres.Port=5432
DB4.Postgres.User=postgres
DB4.Postgres.Password=dbpass
DB5.Name=PT3_2008_05_16_032604-PM04
DB5.Type=postgres
DB5.Postgres.Database=PT3_2008_05_16_032604
DB5.Postgres.Server=localhost
DB5.Postgres.Port=5432
DB5.Postgres.User=postgres
DB5.Postgres.Password=dbpass
DB5.Default=Y
DB6.Name=PT3_2008_05_16_094405-Observed
DB6.Type=postgres
DB6.Postgres.Database=PT3_2008_05_16_094405
DB6.Postgres.Server=localhost
DB6.Postgres.Port=5432
DB6.Postgres.User=postgres
DB6.Postgres.Password=dbpass

[WhiteRider]

That's strange - if it was a default PT3 install then I'd expect one of those passwords to work, but the guide you linked is the right one and should get you sorted.

[dadaas]

I have 9.1.1 and i noticed some unstability, like hud is not updating when tables are changing or people getting kick out... do i need to downgrade it or do something to make it work or this is known issue and you will fix it in near future?

[kraada]

We would recommend downgrading to the latest 9.0 version - there are known stability and data integrity issues with PostgreSQL 9.1 at this time.