Create PostgreSQL Tables

We will be using PostgreSQL tables to store the transaction graph. We will need three tables that are named as follows.

  • xmr_keyimages: Contains transaction rings and key images
  • xmr_outputs: Contains the transaction outputs
  • xmr_bigraph_edges: Contains the edges of the bipartite transaction graph

Do the following before proceeding to the table creation steps.

  1. Install PostgreSQL if you have not already done so.
  2. Set the password for the postgres user via the following commands.
    • sudo su postgres
    • psql
    • \password postgres