Postgres 9.6?

ebsebs Posts: 111 ✭✭
Hi,

Has anyone managed to get OC running on Postgres 9.6? The installation instructions for 3.13 states that point releases should be ok but in the database section it specifically recommends 9.5.

I'm hitting a "column am.amcanorder does not exist" error on initial deployment onto Postgres 9.6 with OC failing to load. This error seems common to many Java applications and may be related to the JDBC driver.

Will 3.14 support 9.6? Nothing specific about it in the Roadmap or in Jira as far as I can see.

Thanks
Eric

Comments

  • kristiakkristiak Posts: 1,249 ✭✭✭
    Hi Eric,

    I have one study running under 9.6. The problem I have is to run PGADMIN 4.0.
    When trying to backup the OpenClinica, I get an error:
    " Please set binary path for PostgreSQL Server from preferences."
    I'm not sure how to fix that!

    Regards

    Krister
  • ebsebs Posts: 111 ✭✭
    Hi Krister,

    That's interesting. Did you need to do any workarounds or fixes to get OC to install? Have you seen any other issues or concerns?

    Your backup issue sounds like this one...... https://dba.stackexchange.com/questions/149169/binary-path-in-the-pgadmin-preferences

    Cheers
    Eric
  • kristiakkristiak Posts: 1,249 ✭✭✭
    Hi Eric,

    No I did not do anything unusual but after I followed the instructions in the link you sent me I got that part to work, But there is one problem with PGADMIN 4.0
    it runs extremely slow or not at all. I cannot get the BACKUP to finish on a small database with 38 patients running on a fast server under WINDOWS 2012 server. Any ideas? I would like to go back to PG 9.5 but I can't get a proper backup so I'm hesitant!

    Best

    Krister
  • BinaryVisionBinaryVision Posts: 38
    kristiak said:

    Hi Eric,

    No I did not do anything unusual but after I followed the instructions in the link you sent me I got that part to work, But there is one problem with PGADMIN 4.0
    it runs extremely slow or not at all. I cannot get the BACKUP to finish on a small database with 38 patients running on a fast server under WINDOWS 2012 server. Any ideas? I would like to go back to PG 9.5 but I can't get a proper backup so I'm hesitant!

    Best

    Krister

    Have you tried with pg_dump?
  • kristiakkristiak Posts: 1,249 ✭✭✭
    Thanks, I will try that! My findings seems to be pretty common when you read reactions from users!
  • kristiakkristiak Posts: 1,249 ✭✭✭
    I was able to get a full backup via PG_DUMP and loaded it into PG 9.5. That part worked fine. BAsed on my experience with PG 9.6 I would not recommend it for OpenClinica.
  • ebsebs Posts: 111 ✭✭
    A followup post to detail how we got OC 3.13 working with PostgreSQL 9.6:

    The main issue I found was that during the normal installation step of deploying the OC war file there were errors in the log file relating to not being able to create Notes tables.

    The following helped get it fully installed:

    1. Deploy OC war file as normal
    2. Stop Tomcat
    3. Change the Database config in the properties file as normal
    4. Start Tomcat (You will see table creation errors in the logs but most tables will be created in the db)
    5. Stop Tomcat
    6. Remove the postgres jar file from $TOMCAT\webapps\OpenClinica\WEB-INF\lib (keep for later step 11)
    7. Download the latest 9.6 Postgres jar file from https://jdbc.postgresql.org/download.html
    8. Copy the downloaded jar to the Tomcat Lib folder, tomcat\lib
    9. Start Tomcat
    10. Stop Tomcat
    11. Remove the postgres jar file from tomcat\lib and copy original Postgres lib file back to OC location
    12. Start Tomcat
    13. OC should be up and running with all tables created in the database(101)

    OC seems to work as normal following this installation but obviously you will need to test it yourself to confirm that on your particular setup.

    @kristiak Upgrading to pgAdmin4.1 improved performance massively for us for backups using the tool

    Cheers
    Eric
  • kristiakkristiak Posts: 1,249 ✭✭✭
    Thanks Eric for the information. I will try this!

    Regards

    Krister
  • skwalerskwaler Posts: 49
    Watch out for this if using extracts
    https://jira.openclinica.com/browse/OC-8141
Sign In or Register to comment.