Welcome to the Tribe...

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.


Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Member
    Points: 9,626, Level: 67
    Level completed: 92%, Points required for next Level: 24
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Nov 2007
    Location
    Puerto Rico
    Posts
    92
    Points
    9,626
    Level
    67

    Default Postgree version

    What is the most recent version of Postgree??
    Dr. Antonio Capella
    Puerto Rico:)

  2. #2
    SOAPware Forum Junkie!
    Points: 13,801, Level: 81
    Level completed: 1%, Points required for next Level: 349
    Overall activity: 15.0%
    Achievements:
    VeteranTagger Second ClassOverdrive10000 Experience Points

    Join Date
    Nov 2007
    Location
    Arlington, TX
    Posts
    1,190
    Points
    13,801
    Level
    81

    Default

    The PostgreSQL website shows the most current version is 9.6.2.

    I believe that SOAPware cloud services runs on version 9.4 which is what I run on my local server.
    Tom Miller MD
    Solo FP
    Arlington, TX

  3. #3
    SOAPware Forum Junkie!
    Points: 11,685, Level: 74
    Level completed: 79%, Points required for next Level: 65
    Overall activity: 0%
    Achievements:
    VeteranOverdrive10000 Experience Points

    Join Date
    Nov 2007
    Posts
    397
    Points
    11,685
    Level
    74

    Default

    I am on PG 8.3! how do I upgrade and is there an advantage?

  4. #4
    SOAPware Forum Junkie!
    Points: 13,801, Level: 81
    Level completed: 1%, Points required for next Level: 349
    Overall activity: 15.0%
    Achievements:
    VeteranTagger Second ClassOverdrive10000 Experience Points

    Join Date
    Nov 2007
    Location
    Arlington, TX
    Posts
    1,190
    Points
    13,801
    Level
    81

    Default

    I believe that PostgreSQL 8.3 is a 32 bit program and 9.0 and above are 64 bit programs. Moving to a 64 bit database program should have some speed improvement. If you are not comfortable working with PostgreSQL I would not recommend attempting the upgrade yourself. SOAPware support might be able to do this for you. The steps to upgrade PostgreSQL include making a database backup with PG (NOT WITH SOAPware database manager), installing the new database, then restoring your data. Backup and restore steps can take several hours depending on your hardware and the size of your database.
    Tom Miller MD
    Solo FP
    Arlington, TX

  5. #5
    Member
    Points: 9,626, Level: 67
    Level completed: 92%, Points required for next Level: 24
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Nov 2007
    Location
    Puerto Rico
    Posts
    92
    Points
    9,626
    Level
    67

    Default

    I also have PosgreSQL 8.3.
    Will call local support for upgrade.
    Dr. Antonio Capella
    Puerto Rico:)

  6. #6
    SOAPware Forum Junkie!
    Points: 7,572, Level: 61
    Level completed: 8%, Points required for next Level: 278
    Overall activity: 22.0%
    Achievements:
    Veteran5000 Experience PointsOverdrive

    Join Date
    Jan 2008
    Location
    Anderson, IN
    Posts
    208
    Points
    7,572
    Level
    61

    Default

    I would like to see SW provide a user-based solution for this upgrade, so we don't have to go through support. I upgraded my server machine recently, with a new install of SW database server, and it installed 8.3. Perhaps an upgrade tool, or even step-by-step instructions? I realize that hardware is variable and doing this might be problematic, but 8.3 is close to nine years old now. I remember seeing discussion of this five years ago.

    Since it can take several hours, the only feasible time to do this is over a weekend, when support is limited. So I'd like to be able to do it myself and make sure it works before opening Monday AM.
    Mark Lawlor, MD
    Anderson Family Medicine, PC
    Anderson, Indiana

  7. #7
    SOAPware Forum Junkie!
    Points: 11,685, Level: 74
    Level completed: 79%, Points required for next Level: 65
    Overall activity: 0%
    Achievements:
    VeteranOverdrive10000 Experience Points

    Join Date
    Nov 2007
    Posts
    397
    Points
    11,685
    Level
    74

    Default

    I have been using a 32 bit program on a 64bit machine. I would like to up grade.

  8. #8
    Senior Member
    Points: 3,895, Level: 41
    Level completed: 64%, Points required for next Level: 55
    Overall activity: 0%
    Achievements:
    1000 Experience PointsVeteran

    Join Date
    Mar 2013
    Location
    Fayetteville, AR
    Posts
    137
    Points
    3,895
    Level
    41

    Default

    If you are interested in upgrading your PostgreSQL version, please contact our Support team by either submitting a ticket at www.soapware.com/ticket or by calling us at 800-455-7627 option 2.

    We do not recommend that customers upgrade their own version of PostgreSQL and HIGHLY recommend you allow our Support technicians to work through this process with your clinic. Our PostgreSQL is a customized version and the process to upgrade to 9.4 is very complicated and includes many variables that even our experienced technicians run in to and have to troubleshoot.

    During the upgrade process, we make sure the database is clean and contains no corrupted documents. If it does, we attempt to repair corruption prior to initiating an update. In addition, documents that are too large in your current database will not convert properly, so we have to go through a process to clean these documents.

    We often do PostgreSQL conversions over the weekend if we can coordinate an available technician with the clinics schedule. We like to begin this process on Friday in order to have the entire weekend to complete the process.

    Again, if you are interested in upgrading your PostgreSQL database version, please contact our Support team to schedule an appointment to begin the process.

    Thank you,
    Krista
    Krista Nicewarner
    Director of Customer Services | SOAPware, Inc.
    800-455-7627 option 2
    clinicaltraining@soapware.com | support@soapware.com

  9. #9
    SOAPware Forum Junkie!
    Points: 7,572, Level: 61
    Level completed: 8%, Points required for next Level: 278
    Overall activity: 22.0%
    Achievements:
    Veteran5000 Experience PointsOverdrive

    Join Date
    Jan 2008
    Location
    Anderson, IN
    Posts
    208
    Points
    7,572
    Level
    61

    Default

    Krista - thanks very much for your reply and information. I toyed with the idea of trying to upgrade on my backup server as practice, but it's not an identical machine to my in-use server. Your post talked me out of that. I've submitted a ticket.
    Mark Lawlor, MD
    Anderson Family Medicine, PC
    Anderson, Indiana

  10. #10
    SOAPware Forum Junkie!
    Points: 14,922, Level: 84
    Level completed: 21%, Points required for next Level: 278
    Overall activity: 30.0%
    Achievements:
    VeteranOverdrive10000 Experience Points

    Join Date
    Nov 2007
    Posts
    612
    Points
    14,922
    Level
    84

    Default

    Soapware techs did a great job upgrading our postgres last year.
    They have a clean and check program that they run first, then the upgrade (after a backup).
    I do wish there was an automated way to create our own server from scratch with 9.4. I think the current database creation application still uses 8.x? Soapware techs helped to also upgrade our backup server and get that running too. They asked me about it before I had a chance to mention it. Excellent support.

 

 

Posting Permissions

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