restore from data folder

[andretti]

hi,

at the moment i have data directory from old PC based on WinXP(x86) (data directory was copied after postgresql service had been stopped)

now i have almost clean Win7(64bit) installed and "PT3 DB is not a valid PokerTracker Database" error message(after having installed postgres wiht having "my data folder" as it should be)

Could You guys help me, please?

BTW, minor version of PokerTracker3 is the same. 5.2

thank you

[WhiteRider]

Have a look at How to reinstall PostgreSQL for information on how to reconnect to an existing Data folder.

[andretti]

i did it according to guide, but PT3 does not recognize it still
however pgadminIII can recognize it

[kraada]

In that case, please upgrade to Beta 29.1 as it has additional features to help locate errant PostgreSQL databases on startup.

[andretti]

thanks for your assistance, but..

It does not make any sense(additional functions are promoted from pgAdmin), however I did it.
Picture remains the same.

It seems to me thats smth wrong with database.
1. I am pretty sure i stopped PostgreSQL service before copying data directory.
the only thing i made was changing password to the database "PT3 DB"

2. pgAdmin does open it, but the backup which can be performed from pgAdmin GUI is about 12Kb, however the size of "data" is ~ 4Gb.
btw return code of the backup is 0(i presume its successfull)

3. If I try to ReIndex the ouput is following:
----------------------------------------------------
NOTICE: table "pg_class" was reindexedNOTICE: table "sql_features" was reindexedNOTICE: table "sql_implementation_info" was reindexed
ERROR: could not access status of transaction 2697049
DETAIL: Could not open file "pg_subtrans/0029": No such file or directory.

ERROR: could not access status of transaction 2697049
DETAIL: Could not open file "pg_subtrans/0029": No such file or directory.
---------------------------------------------------

file is absent indeed:)

Any other thoughts?

thanks in advance

[kraada]

Click Start --> Programs --> PostgreSQL --> psql to 'postgres'. At the prompt type \l and hit enter to list databases, then \connect "Your Database" and hit enter to connect to the PT3 database in question. The prompt will change to indicate you've connected to your database. Once there hit \d and hit enter and paste the results here.

[andretti]

postgres=# \connect "PT3 DB"
You are now connected to database "PT3 DB".
PT3 DB=# \d
List of relations
Schema | Name | Type | Owner
--------+---------------------------+-------+----------
public | lookup_actions | table | postgres
public | lookup_hand_groups | table | postgres
public | lookup_hand_ranks | table | postgres
public | lookup_hole_cards | table | postgres
public | lookup_positions | table | postgres
public | lookup_sites | table | postgres
public | lookup_tourney_table_type | table | postgres
public | lookup_tourney_type | table | postgres
public | settings | table | postgres
(9 rows)

PT3 DB=#

[kraada]

That is not even close to a complete PT3 database (it's not even 1/3 of it); do you still have the hand histories from the old computer? What's probably easiest if you have them is to reimport all of the hands from the hand histories into a new database.

[andretti]

thats the problem, unfortunately not

[kraada]

Did you copy the entire data folder including all of its subfolders over?