Skip to main content

Working with our PostgreSQL database

warning

WIP

Accessing Crunchy Bridge​

  • Go to Crunchy Bridge: https://crunchybridge.com/
  • Log in with your brimstone.com email address (through Microsoft or directly)
  • Go to the Brimstone team in the top left selector
  • Select the DB of interest
    • development and production are the dev and prod DBs respectively
    • ignition-db is used for Matt's SCADA server in Oakland
    • The other ones are deprecated and should not be used

Getting PostgreSQL connection details​

  • Follow the general instructions and pick a DB.
  • Go to the "Connection" page in the sidebar on the left
  • Pick a role
    • user: this is a read-only role that has access to all tables
    • application: this is a read-write role that has access to all tables (or nearly all). This is the role used by our services, including Dagster, Stoneware, etc...
    • postgres: this is a superuser (= admin) role. Only use it for very high-level administrative tasks. Do not use it to create tables or schemas, as application won't be able to use them without additional grants.
  • Note: you may not have access to all roles, depending on your rights. If you need to use a role not available to you, reach out to Erwin.
  • Pick your desired format and export the credentials

Relatively soon, we will introduce more fine-grained data controls, at which point those instructions will be updated.