Corda postgres table setup during the deployNodes

Question

I'm trying to build nodes which needs to be deployed in Multiple VM's. When I run the deployNodes, the corresponding tables are getting created.

Is there anyway that after copying the nodejs to VM and execute commands to generate the tables on the Postgres in the corresponding VM machines.

Adel Rustum · Accepted Answer · 2020-05-21 11:29:42Z

1

First, you need to create one schema per node inside your database. For instance, here you can find the steps for PostgreSQL database.
Then, set initializeSchema to true inside the node.conf of your node; with this option enabled, the node will automatically create all its tables when it starts for the first time.

answered May 21, 2020 at 11:29

Adel Rustum

2,5482 gold badges9 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sneha Damle · Accepted Answer · 2020-05-25 11:13:35Z

0

DeployNodes is a Gradle plugin which will help you to set up the node configurations. Database tables are created only when you run the node. You connect to the default in-memory H2 database or you connect to Postgres, the logic to generate the tables in the database is the same. By default, all the required tables are generated automatically by the node in the database.

answered May 25, 2020 at 11:13

Sneha Damle

6341 gold badge5 silver badges6 bronze badges