Backup Funktion: Default Parameters Error

[moeb1us]

Hi there.

I'm on a win xp with postgresql 8.0.3 and PT3 in v3.12.1 and I'm planning on moving to a win7 x64 with a newer postgresql as well.

My reasoning was to first backup the pt database. Since I have the PT3 quite a long time, I think the File/Backup functionality was not implemented the last time I used it. I am kind of conservative with my programs and have continued to use the pgAdmin III to do by backups (I knew it worked, I did not need to read and learn stuff etc pp, limited time/resource problem).

So, I tried out the Menu File/Backup, but there pops up a message box with an error like: Unable to login to database (postgres). Reason: FATAL: database "postgres" does not exist
I clicked 'configure defaults' and looked at the settings, they seemed fine except the password (Server: localhost, port: 5432, Database user: postgres, password: dbpass) so I changed the password to the correct one and tried again. Same message same error.
I frowned and fired up pgAdmin, used the password to connect to the database and checked the properties there. Hostname is localhost, port is 5432, Initial database is template1, username is postgres. What the heck I thought.

What am I missing? Is the build-in backup/restore not compatible with postgresql 8.0? Do I have to update that first? And regarding the error message: DATABASE POSTGRES does not exist - of course not, that is the effin user name, not the db name. The db is called 'party', at least in pt3 in the field Database Name (in the DB Management Window). Under Database Info the Database is called 'PT3 DB', which is a string I can see in pgAdmin as well, in the tree 'Databases', and there is the CREATE DATABASE "PT3 DB" command as well.

In pgAdmin, there is a second database in the tree Databases, its called PARTY-POSTGRESQL-VERSION, but in PT3 I don't see that. Can't remember why its there actually. It has 22 tables that are different from the 52 tables the 'PT3 DB' has. Tables start with blind_structure and datawindow_prefs, dst, error_msgs and so forth, contain pLayer_winnings as well. The other db starts with holdem_cache, holdem_hand_histories instead and contains many lookup_*, omaha_* and tourney_* tables. Confusing.

I can not really think of other logical explanations. I am kind of stuck here.

Please help me out with some suggestions on how to proceed, thank you very much.
moe

[kraada]

The first thing I would do is definitely try the backup function - it's a wrapper around pg_dump so at worst what will happen is it will give you an error and that will be that. It sounds like you actually expanded your database in PGAdmin - those are tables within a PT database.

Either way though, start with PT's backup system, that will be the easiest road if it works and there's no penalty for trying.

[WhiteRider]

Do you really mean PostgreSQL 8.0? That is very old and is not supported by PokerTracker and the Backup/Restore may not work correctly.

[moeb1us]

Hey. Sorry I took so long but I was out of the country work related.

@kraada: Which backup function/wrapper do you mean exactly? Because if you mean the integrated one in PT3, I have already done that. Check for "So, I tried out the Menu File/Backup, but there pops up a message box with an error like: Unable to login to database (postgres). Reason: FATAL: database "postgres" does not exist ..." in my post.
So the worst thing happened, it doesnt work and that's that

@WhiteRider: yes I am quite sure about the version. I think I looked it up during the post. And it must be supported by pokertracker, because the only reason I would install postgresql would be to run my pokertracker... I have no other uses for it? Now I am really confused...my PT3/PostgreSQL combo works quite well...the only thing is it runs on the wrong system ^^

So, let me wrap that up: You and me have no clue what to do exactly because it's a mess and a stone-age postgres. So...what are my options? Install PT3 on new system and reimport all hands or what? Are there alternatives? ^^

[kraada]

Can you connect to the database via PGAdmin? If so you could take a backup there as explained in this post. The backup should restore in newer versions properly.

[moeb1us]

Yes, like I wrote in my initial post, I can connect to the DB and do a backup there.

So I should be able to use the created backup files with pgAdmin in the installed PT3 on the new computer through the integrated restore dialogue yes?

Thank you I will try that out this weekend and report back.

[kraada]

You'll need to restore it still through PGAdmin - our restoring expects certain other files in specific locations. But once you restore it in the new PostgreSQL installation you can find it in PT3 via Database --> Database Management --> New --> Browse.