Blockchain Development for Finance Projects

Creating the bank databases

Next, we'll create two databases, banka and bankb, each corresponding to Bank A and Bank B. Additionally, we'll create two database users, banka and bankb, each corresponding to the banka and bankb databases. Each database will contain the customers table, which will hold customer data, and transactions table, which will hold transaction data.

Follow these steps:

Switch to the postgres user, like this:

$su - postgres

Create two new users for each database, like this:

$ createuser banka --pwprompt

Enter the password as banka, or anything else. We'll need this password later for connecting to the banka postgres database. Repeat the same for the bankb user, as follows:

$ createuser bankb --pwprompt

Enter the password ...