Skip to content

Database Schema Management

Jump to bottom
Oliver Gorwits edited this page Dec 31, 2024 · 1 revision

  • The database schema credentials are available from the Heroku account (postgresql add-on settings panel)

  • When db creds change, update:

    • Heroku web dyno environment settings
    • GitHub organisation Actions secrets

  • Dump the database content using command pg_dump -Fp -xO -n public -h xxx -U xxx -d xxx -f netdisco2-demo-cumulus-clean.db.sql

    • Probably want to first log in (with psql URL) and empty the snmp_objects and admin tables
    • Comment out the SET lines at the top of the dump file, except for the UTF8 encoding command
Clone this wiki locally