Reparing PT2 DB

[ptrack pat]

Go to the Start > Settings > Control Panel > Administrative Tools > Services window.

Find PostgreSQL 8.2. in the list.

Right-click on it and select "Start" from the popup menu.

What happens when you do this? Does it give an error at all?

When did you backup these db's last?

[Mocky]

it says "windows is attempting to start the service" then the pop up disappears, i get no errors.
Have not backed up in a month.

Dont know if its relevant but when i click on ring game statistics i get the following message

"database transaction information not available
call SetTrans or SetTransObject function."

[ptrack pat]

Did you install/update any kind of firewall software before this error started?

Go to the c:\program files\postgresql\8.2\data\pg_log folder. Is there a file with today's date in the name there? If so, open the file and copy/paste the text of that file into a reply.

[Mocky]

I havent installed any new firewall recently however windows did auto update a few days ago.
Todays log is empty however this is the first entry from yesterday

2008-04-10 16:21:56 FATAL: the database system is starting up

2008-04-10 16:21:56 LOG: database system was interrupted at 2008-04-09 10:11:12

2008-04-10 16:21:56 LOG: checkpoint record is at 1/B7EC3330

2008-04-10 16:21:56 LOG: redo record is at 1/B7EC3330; undo record is at 0/0; shutdown TRUE

2008-04-10 16:21:56 LOG: next transaction ID: 0/7321747; next OID: 49152

2008-04-10 16:21:56 LOG: next MultiXactId: 1; next MultiXactOffset: 0

2008-04-10 16:21:56 LOG: database system was not properly shut down; automatic recovery in progress

2008-04-10 16:21:56 LOG: record with zero length at 1/B7EC3380

2008-04-10 16:21:56 LOG: redo is not required

2008-04-10 16:21:56 LOG: database system is ready

2008-04-10 16:22:16 LOG: received fast shutdown request

2008-04-10 16:22:16 LOG: shutting down

2008-04-10 16:22:17 LOG: database system is shut down

2008-04-10 16:22:17 LOG: logger shutting down

[ptrack pat]

Go to the C:\Program Files\PostgreSQL\8.2\data folder. There should be 9 sub-folders there named...

base
global
pg_clog
pg_log
pg_multixact
pg_subtrans
pg_tblspc
pg_twophase
pg_xlog

Do you see all of these sub-folders? If not, which are missing?

[Mocky]

All 9 sub folders are there.

[ptrack pat]

ZIP the entire c:\program files\postgresql\8.2\data folder so you have a backup of all the data files.

Use the Start > Settings > Control Panel > Add or Remove Programs window to uninstall PostgreSQL. Uninstalling will still leave the entire c:\program files\postgresql\8.2\data folder intact.

Go to the Start menu and select Run. Type COMMAND on this window to open a DOS window. Type:

net user postgres /delete

into the DOS window and hit ENTER to run it. Type EXIT to close the DOS window.

Download and reinstall PostgreSQL as detailed here:
http://www.pokertracker3.com/products/P ... InstallSQL

EXCEPT FOR WHEN YOU GET TO THE WINDOW that has "Initialize database cluster" at the top. UNCHECK THAT BOX and then click the Next button. This will cause it to try to reuse the old ../data folder which has your databases in it.

Once installation completes, restart the computer and try it again.

Hopefully this will work. If it doesn't I'll have to tell you how to send the ZIP file to me with your data folder and I can try to recover your databases for you.

[Mocky]

Just tried this but it didnt work, when i open PT i get the same messages.

[ptrack pat]

What is the size of the ZIP file you made that contains the backup of the ../data folder?

[Mocky]

its a winRAR ZIP archive 25.6mb