Setting up your PostgreSQL database - chicklightning/tcg-pocket-trading-bot GitHub Wiki

Now it's time for us to set up a local Postgres database so we can store user data, cards and trades.

  1. Open pgAdmin 4 (this is the user interface that lets us interact with locally-stored databases)
  2. Set a master password
    • IMPORTANT: Like your superuser password, be sure to save this somewhere so you can access it again later if needed.
  3. Enter the superuser password to connect to your PostgreSQL server when prompted; opt to save the password and press "Ok"
  4. Right-click the line "Databases" and select "Create" then "Database..."
  5. Name the database "tcg-pocket-dev", like the name in the screenshot above
    • You can choose a different owner for this database other than "postgres" if you want; I created a new owner with a different password and assigned that owner to this database. But this is not necessary.
  6. Select "Save"

You have now set up your database that our bot will connect to!

Next steps

Next, you will want to set up your environment variables for the project.