How to connect postgresql in canton?

Questions
1

Hi Team,

PQS (Private Query Store) contains postgresql db and ledger component (Scribe). I have installed postgresql in the VM where I have started canton domain and participant node natively. But Scribe is not an open source file. In the documentation, It is mentioned that canton open source supports postgresql. Without Scribe, how to connect participant nodes and postgresql? And using client app (Java) how to access the daml smart contract/how to store/query the data?

2

Hi Manju,

The Daml documentation contains comprehensive guidance on how to source & configure Canton Open Source, select an appropriate Data persistence method (Postgres Native/Docker), and using the various client applications to interact with the Canton Ledger.

These are the initial steps that you will need to work through to achieve a minimal Canton Open Source configuration, and you will need to read through the workflow a few times to understand the correct setup method for your particular situation.

If you have any issues from each of these steps, please perform a search within the Daml Forum itself, using the SEARCH function at the top right, see the attached screenshot below.

If that does not produce useful results, perform a wider Google search with any relevant configuration strings or reported errors.

Then revisit the documents, and if you are still having issues, please create a new, specific Forum Post with the usual information:

  • Current application version
  • What you were trying to do
  • What you have done
  • What was the result
  • What were the reported errors
  • Is there any relevant screenshots or logging that you can supply

Note: If you supply logging, please make an effort to trim it to the most relevant portions.

Good luck!

SCR-20240111-iwve