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 imagesxmr_outputs
: Contains the transaction outputsxmr_bigraph_edges
: Contains the edges of the bipartite transaction graph
Do the following before proceeding to the table creation steps.
- Install PostgreSQL if you have not already done so.
- Set the password for the
postgres
user via the following commands.sudo su postgres
psql
\password postgres