Error when trying to backup Postgres database

[Rycky4Golf]

I've never had this happen previously. Here is what I get now:

ERROR message from server: ERROR - column "oprlsortop" does not exist

It also says ERROR 1 at the end of the window. I tried to post a screen shot but was unsuccessful, if I can pull it off I'll post it.

[ptrack pat]

I've never seen this before. That's not a column in the PT database so it must be a column from a system table or something like that. I don't know what to tell you. When was the last time you backed up the database before this error started?

[Rycky4Golf]

Probably just a couple weeks ago.

[Rycky4Golf]

pg_dump: reading indexes for table "tourney_summary"
pg_dump: reading constraints
pg_dump: reading triggers
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: column "oprlsortop" does not exist
LINE 1: ...re, oprjoin::pg_catalog.regprocedure, oprcanhash, oprlsortop...
^
pg_dump: The command was: SELECT oprkind, oprcode::pg_catalog.regprocedure, oprl
eft::pg_catalog.regtype, oprright::pg_catalog.regtype, oprcom::pg_catalog.regope
rator, oprnegate::pg_catalog.regoperator, oprrest::pg_catalog.regprocedure, oprj
oin::pg_catalog.regprocedure, oprcanhash, oprlsortop::pg_catalog.regoperator, op
rrsortop::pg_catalog.regoperator, oprltcmpop::pg_catalog.regoperator, oprgtcmpop
::pg_catalog.regoperator from pg_catalog.pg_operator where oid = '16542'::pg_cat
alog.oid
pg_dump: *** aborted because of error



Error 1 has occurred ==== BACKUP FAILED TO COMPLETE!!!
Press any key to continue . . .

[ptrack pat]

You are going to have to use the Utilities > Export Hand Histories to File option to export the hands since your last backup. Then restore the old backup file and reimport the files you exported to get the database back in sync.

[Rycky4Golf]

It seems this failed backup overwrote my previous backup, so it looks like I'm screwed unless you know another way I can fix this.

I do have access to the old laptop that had some of my stuff on it, but it'll be a lot of work to import all the stuff since that time. I did export some files but some of the info from the summaries didn't transfer over, namely the buy-in amounts for AP/UB and some for FTP also. Why would it do that?

[ptrack pat]

You need to make sure when you do backups to select a new file name to backup to (i.e. use the date in the file name, like backup_09142009.backup or something like that) and not overwrite a previous good backup. There is no way to recover that now.

The tournament summary information is entered manually, that doesn't get exported. You would need to manually re-enter that information.

[Rycky4Golf]

OK, I went back to my old laptop, backed up what I had there and moved it to the new laptop. I then took the time to reimport and reenter all the games I had played. Unfortuneately I still have the same exact problem when trying to make a backup. Is there any other way to backup my file? Also, PT2 refuses to print reports. The message I get is this:

Error - Access violation at 0x106DE0FB (tried to write to 0x03C41000), program terminated.

Then PT fails to respond and I have to reboot it. Are these issues related or can the printing of reports be fixed?

[ptrack pat]

"oprlsortop" is from a system table, it's not even a PT table that this is coming from so I have no idea what would be corrupting the database on this computer. The fact that you are also getting those other errors while trying to print reports makes it sound like there is something wrong with disk possibly. I've never had anyone report those kinds of errors while printing reports.

What version of PostgreSQL did you install? Was it 8.2 or 8.3?

Open pgAdmin III - right-click on the red X at the top left corner and select connect. When prompt for a p/w, hit enter.
Now click on Databases > [your PT2 db name] > Schema > pg_catalog > Tables
In the list of tables, find "pg_operator" and click on + sign and then click on "Columns".
Is the column called "oprlsortop" shown there?

[Rycky4Golf]

I loaded both, I've always had to load both 8.2 and 8.3 in order to get the ports to show in PT2. I've done this on all 3 computers I've set up and never had problems. I use 8.3 for my database.

Going where you directed me, under schemas I have "public", under tables I have 22 items listed but none are called "pg_operator".

I looked around and found it under Catalogs > PostgreSQL. In there I found a number of tables starting with "opr" but no "oprlsortop" was listed.