PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – Postgres local for Guidewire cloud development

This is about using Postgres in local for Guidewire development to work around memory constraints and to deal with large data sets. Also thinking using postgres in local will make us closer to production setup for troubleshooting.

My plan is to install a compatible PostgreSQL database version locally. This can be done either as an independent installation or using a Docker image. Connect the Guidewire application to the database using JDBC.

I haven’t attempted this yet, but I’m planning to. Any one attempted this yet?

Tags:

2

Answers


  1. 0

    The Jasper support Matrix does indeed list Amazon Aurora PostgreSQL (13.9 or 12.9) as compatible for Local Development environments. I would think this implies that you would have to connect your local Jetty server to an AWS Aurora PostgreSQL instance, not a generic local PostgreSQL. You can certainly try to connect your Jetty server to a local PostgreSQL instance, and the documentation lists how to specify this in the database-config.xml (copied from documentation below):

    Login required for link to work
    https://docs.guidewire.com/cloud/cc/202402/admin/admin/topics/database/r_hu1667728.html

    <database name="ClaimCenterDatabase" dbtype="postgresql">
        <dbcp-connection-pool jdbc-url="string" max-idle="200" max-total="integer"/>
</database>

    I would imagine there would be a little bit of configuration you would need to do to your local PostgreSQL DB before starting the Jetty server such as creating the ccUser (for ClaimCenter) and setting the correct permissions. There aren’t really any details like with the on-premise versions of what you need to configure in the DB server so this will probably take some tinkering on your end to get it to work. Good luck.

    I should also note that I have not done this myself and I would imagine there is a chance this may not work at all. So decide how much effort you’d like to devote to this wisely.

    Login or Signup to reply.
  2. 0

    I have lightly used postgresql locally. This is my configuration from database-config.xml. I was able to quote and bind a policy, but had some issues with importing xml data. You have to get the charset correct when you create your database.

    <database
    autoupgrade="full"
    dbtype="postgresql"
    env="{localenvname}"
    name="PolicyCenterDatabase">
    <dbcp-connection-pool
        jdbc-url="jdbc:postgresql://localhost:5432/{dbname}?user={username};password={password}"
        max-idle="200"
        max-total="200">
        <reset-tool-params system-password="gw"/>
    </dbcp-connection-pool>
</database>
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search