How to connect PostgreSQL database using pg admin to corda instead of H2 database ?
What are the changes to be done in node.conf file before the nodes are up ?
-
3Possible duplicate of Using PostgreSQL instead of H2 as the Corda node's databaseRaj– Raj2018-08-31 10:17:07 +00:00Commented Aug 31, 2018 at 10:17
-
See above. This is indeed a duplicateCais Manai– Cais Manai2018-09-01 22:59:36 +00:00Commented Sep 1, 2018 at 22:59
Add a comment
|
1 Answer
As mentioned in the comments, all you need is adding the followings node.conf file after you have generated your node.
dataSourceProperties = {
dataSourceClassName = "org.postgresql.ds.PGSimpleDataSource"
dataSource.url = "jdbc:postgresql://[HOST]:[PORT]/postgres"
dataSource.user = [USER]
dataSource.password = [PASSWORD]
}
database = {
transactionIsolationLevel = READ_COMMITTED
}
And please remember to wrap all the string values with double quotes (eg. "Username", "Password")
