postgres-database.md

Postgres Database

When running on Heroku, we use a Postgres database supplied by Heroku.

Accessing Database Console

• On Heroku, with CLI:

  • Use: heroku psql --app app-name-here

  • Note that this requires that you have the psql CLI tool installed on your system.

  • This does work on CSIL, but you may need heroku login -i in order to login on CSIL

  • Example:

    [pconrad@csilvm-03 ~]$ heroku psql --app demo-spring-react-example
    ›   Warning: heroku update available from 7.59.1 to 7.59.2.
    --> Connecting to postgresql-tapered-84555
    psql (13.4, server 13.5 (Ubuntu 13.5-2.pgdg20.04+1))
    SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
    Type "help" for help.
    
    demo-spring-react-example::DATABASE=> 
    

• On Heroku, without CLI:

  • Upper right of dashboard, select "More" then "Run Console"

    

  • Enter psql $DATABASE_URL and click Run

    
• Cheatsheet of psql commands: https://www.geeksforgeeks.org/postgresql-psql-commands/