transferring (big) db during upgrade from postgreSQL 8.2 to 8.3
Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default transferring (big) db during upgrade from postgreSQL 8.2 to 8.3

    I didn't see anything in the faq and couldn't find any relevant threads via search. Is it as simple as just backing up my db and restoring it into 8.3 (presumably via PGAdmin)?

    Thanks.

  2. #2
    Senior Member Al1's Avatar
    Join Date
    Aug 2008
    Location
    Geneva
    Posts
    2,873

    Default

    About the backup of your Database, there is 3 solutions:

    1) http://208.109.95.123/faq/afmviewfaq.aspx?faqid=12 (FAQ)
    2) http://208.109.95.123/forum/showpost...54&postcount=2
    3) Just reimport all your hands from your saved HHs.

  3. #3
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default

    Quote Originally Posted by Al1 View Post
    About the backup of your Database, there is 3 solutions:

    1) http://208.109.95.123/faq/afmviewfaq.aspx?faqid=12 (FAQ)
    I did see this, just wasn't sure if the switch from 8.2 to 8.3 would cause a problem w/ it.

    Now that you mention it, I do remember reading that thread in the past. The text commands fabio wrote do look kinda familiar (similar to the format of those I used to cluster PT2), but I'm not really sure how to go about this.

    3) Just reimport all your hands from your saved HHs.
    Yea, but the db is several million hands, I'd rather not.

    I guess I'll try the first method, thanks Al.

  4. #4
    Senior Member Al1's Avatar
    Join Date
    Aug 2008
    Location
    Geneva
    Posts
    2,873

    Default

    Have you resolved your issue?

  5. #5
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default

    After some more searching I gathered that I couldn't use method 1 when upgrading from 8.2 to 8.3, so I tried fabio's way but couldn't figure it out. So I just used method 3 on my most recent, small db, and I guess I'll tackle the big one whenever I have the time.

    I haven't dumped the old (big) db yet, tho, so if somebody feels like breaking down fabio's method into step-by-step instructions I'll try it again.

    As an aside, after I imported the exported hands from my small db, the vacuum function in HM didn't work. The cmd window popped up and asked for a password or something.

  6. #6
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Press the windows key(flag) + R or go to Start > All Programs > Accessories > Run and then type cmd

    This will open a new window

    type cd c:\program files\postgresql\8.x\bin and press [ENTER] then type
    run pg_dumpall -U postgres > c:\dbbackup.sql and press [ENTER]

    You need to replace c:\program files\postgresql\8.x\bin with the path that PostgreSQL is installed on and also change 8.x to 8.3 or 8.2 depending on what version your using.

    This may take a while but the end result will be that your entire postgres database will be backed up to a file. If you want it saved to a different folder just change that c:\dbbackup.sql to something more fitting.

    Press the windows key(flag) + R or go to Start > All Programs > Accessories > Run and then type cmd

    This will open a new window

    type cd c:\dbbackup.sql then press [ENTER]
    and type psql -U postgres -f c:\dbbackup.sql postgres and then [ENTER]

    This should safely backup and restore between versions
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  7. #7
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default

    I will try that, thanks.

    One more thing- 8.2 is using port 5433. So I need to use something like...
    run pg_dumpall -p 5433 -U postgres > c:\dbbackup.sql, right?

    8.3 is using the standard port 5432.

  8. #8
    Tech Support Manager morny's Avatar
    Join Date
    Jul 2008
    Location
    Ireland
    Posts
    20,888

    Default

    Yeah thats unusual as it uses 5432 by default so you must have changed it during that installation for some reason, maybe 5432 was busy. To be honest im not sure and i suspect you need to use the current port so try 5432 first and if that dosent work try 5433
    --------------------------------------------------------------------------------------------------------------------
    We welcome any feedback on any solutions we provide, this helps us to provide better quality solutions in the future.

  9. #9
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default

    Quote Originally Posted by morny View Post
    Yeah thats unusual as it uses 5432 by default so you must have changed it during that installation for some reason, maybe 5432 was busy.
    Yea, this was way back when I first installed postgreSQL for PT2...I couldn't get 5432 to work and didn't really know what I was doing so pt pat or somebody told me to just use 5433.

    To be honest im not sure and i suspect you need to use the current port so try 5432 first and if that dosent work try 5433
    I'll try both, thanks.

  10. #10
    Member
    Join Date
    Sep 2008
    Posts
    55

    Default

    So something's up w/ postgre 8.2- I keep getting this "server doesn't listen" error message and the service can't even be started. I tried w/o my firewall/av/etc, so I don't think that's it. Maybe I messed something up in trying to do all this.

    I saw one guy here had the same prob and his "fix" was to start a db on a diff windows account- haven't been able to find any more info other than that.

    8.3 is working fine.

Similar Threads

  1. How to upgrade
    By mike2405 in forum Manager General
    Replies: 3
    Last Post: 11-28-2008, 11:18 PM
  2. Cant locate HM map for upgrade
    By Arecal in forum Manager General
    Replies: 1
    Last Post: 11-08-2008, 06:51 PM
  3. Transferring to hem from pt3
    By ferrisbueller in forum Manager General
    Replies: 5
    Last Post: 10-22-2008, 07:21 PM
  4. upgrade postgresql after installing HM?
    By b0rt in forum Manager General
    Replies: 1
    Last Post: 10-04-2008, 09:14 AM
  5. Upgrade doesn't work
    By WantAWatch in forum Manager General
    Replies: 1
    Last Post: 08-09-2008, 06:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •