Connecting to pg_data on second HD with new PT3 install

[Kevweiser]

I reformatted and installed win 7 64 (had vista 64 before), then I installed PT3, which works. Prior to upgrading I had all my data on a secondary HD, which is still there inside a folder "E:\pg_data". How do I get this fresh install of PT3 to use that data?

[kraada]

Edit the postgresql.conf file and set the data directory to E:\pg_data\ then restart PostgreSQL and it should look in the new location.

[Kevweiser]

In the file: "C:\Program Files (x86)\PostgreSQL\8.3\data\postgresql.conf"
I set the data_directory to:

data_directory = E:/pg_data/

Via the event viewer I get the following error message:

postgres: could not find the database system
Expected to find it in the directory "E:/pg_data",
but could not open file "E:/pg_data/global/pg_control": No such file or directory

My E: drive just has the following relevant files in it:
E:\schema.postgres.sql
E:\pg_data\PG_VERSION (Says version 8.3)
E:\pg_data\pgsql_tmp\ (Which is empty)
E:\17094\ (Contains 7 gigs of data)

When I put the data on the second drive, it was probably Aug 2008, so maybe the method I used back then was different then how most people do it now?

[Kevweiser]

Edit:
Meant to say
E:\pg_data\17094\ (Contains 7 gigs of data)

[kraada]

If you just used a tablespace then you do not have all of the information required to reconstruct the database. Using a tablespace splits the main chunk of the data onto a secondary hard drive and balances the load between the two for certain functionality - as such there is still some information on the primary hard drive and just the tablespace data alone is insufficient for database recovery.

[Kevweiser]

Hmmmm.... I should technically have all the information I need still. Before I installed win7 I did a back-up of my C drive. What other data do I need?

[Kevweiser]

FWIW, these are the instructions I originally followed to set this up:
http://www.pokertracker.com/forums/view ... tablespace

I attempted to use window's backup/restore to put PT3 and PG into the same state as they were before my re-install. This has 2 problems. First, apparently executable and symbolic links do NOT get backed up by windows. So, I used the exes from a new install, which get's PG and PT3 running. From using PGAdmin I can see that the table space "spare_disk" is correctly being identified, however, when I click on the tablespace I get an error saying that "pg_tblspc\17093\17094" can not be found. I think this is because the symbolic link did not get backed up. So I created one using mlink, which get's rid of this error.

Now, when I run PT3 I see the DB which has all of the data and I am able to connect to it, but the Queries are not returning anything and I see a red error message that says "Query does not have a result set."

So, perhaps there are other symbolic links that didn't get backed up?

[Kevweiser]

Ok, I guess what I did sorta worked. I didn't realize but I was able to successfully query the db, just not from the graphs tab. I exported all the hand histories and now plan to re-installed PT3 and import all those hands. That should fix everything.

[WhiteRider]

Thanks for the updates - if you continue to have problems please let us know.