migrate database from 9.1 to 8.4

[spoksik]

i want to backup player notes on my postgres 9.1, but i find out that i cant, and its only work with 8.4.

So, is there any possibility to migrate database from 9.1 to 8.4?



Or any way to copy player notes from database? via postgres console, pgadmin ?

[DogNamedBluff]

I have escalated this to our 2nd level support techs. They will be in touch shortly.

[DogNamedBluff]

So, is there any possibility to migrate database from 9.1 to 8.4?
Or any way to copy player notes from database? via postgres console, pgadmin ?

I am sorry to inform you but this is not possible.

[spoksik]

I am sorry to inform you but this is not possible.

it's possible. i find a way but i dont know postgresql to do this:



Left table is table from "player_notes" and right table is table from "players". player_id integer from left table (1285) match player_id [PK] serial from right table which is 19roland198. I checked him in HM2 and its his note. So we could write query which will pull out all player notes and write them into new databse only if this player exist.


I think that will take 5 min someone who is good with PSQ

[udbrky]

I ran it by one of our guys who is really good with SQL, and he says there is no way to do the database migration.

I'm not sure about just getting the notes. I haven't done a lot with SQL queries personally.

[spoksik]

i ran it by one of our guys who is really good with sql, and he says there is no way to do the database migration.

I'm not sure about just getting the notes. I haven't done a lot with sql queries personally.

OK, I DID IT !!!

i pull player notes from 9.1 and put them in 8.4

1. Install PostgreSQL 8.4 Install PostgreSQL and phpPgAdmin in Windows with Wamp | Where Tutorial and Technology Meets (u will get two independent postgresql databases)

2. Log in to PostgreSQL 8.4 database by pgAdmin3 and register a new role and give it all rights.

3. Log in to PostgreSQL 9.1 database by pgAdmin3 and register a new role and give it all rights.

4. Left click on tray icon of WAMP server, choose www directory

5. Copy this: [PHP] export playernotes holdem manager - Pastebin.com to notepad and save with php extension, playernotes.php.

6. Left click on tray icon WAMP server, choose PUT Online

7. Open browser and type: http://localhost/playernotes.php

That's ALL, GG QQ.

Greets, thanks, hello for my friend, master of PHP: DJMRZ

[spoksik]

I ran it by one of our guys who is really good with SQL, and he says there is no way to do the database migration.

I'm not sure about just getting the notes. I haven't done a lot with SQL queries personally.

ok i did it.

I pull player notes from PSQ 9.1 and put them in PSQ 8.4

Here it goes:

1. Install PSQ 8.4, WAMP server and phpPgAdmin Install PostgreSQL and phpPgAdmin in Windows with Wamp | Where Tutorial and Technology Meets

2. Log in to PSQ 8.4 with pgAdmin3 and set a "new role", give all rights

3. Log in to PSQ 9.1 with pgAdmin3 and set a "new role", give all rights

4. Left click on tray icon WAMP server, choose www directory

5. Take this php code: [PHP] export playernotes holdem manager - Pastebin.com past it to notepad and save it in "www directory" with php extension - playernotes.php

6. Edit, and change connection info to both databases (fill with info from "new role" (dont use default login and passoword - it wont connect )

7. Left click on tray icon WAMP server, choose PUT online

8. Open internet browser and type: http://localhost/playernotes.php

9. DONE GG QQ OP

Greetings for my buddy - PHP, and MySQL MASTER DJMRZ for helping me