Skip to content

Latest commit

 

History

History
43 lines (31 loc) · 1.63 KB

Solution10.md

File metadata and controls

43 lines (31 loc) · 1.63 KB
Raw

Problem 10: Connecting PGAdmin4 to Heroku

NOTE: JhipsterPress is changing its name to Springular, so be aware of it! I apologize for the inconvinience

May be you need to use PGAdmin to load the database with test data as in our InsertsInPOSTGRESQLDatabaseV8BLANK.txt

You can either see this video: https://www.youtube.com/watch?v=GAHsl0AfK-0 or follow the steps:

First, use the data from your Database Credentials at your Heroku Account to fill the Create a New Server PGAdmin's form:

Then, you will have to configure that information in your application-prod.yml:

/jhipster-press-08/src/main/resources/config/application-prod.yml

spring:
    devtools:
        restart:
            enabled: false
        livereload:
            enabled: false
    datasource:
        type: com.zaxxer.hikari.HikariDataSource
        url: jdbc:postgresql://@ec2-50-17-250-38.compute-1.amazonaws.com:5432/d5u8osf3cgtlg
        username: seejtnnivrl???
        password: e9ed17c73da7ec36bf6eead010968106439debe16ed3df9039be0a9aef??????
        hikari:
            auto-commit: false

You will get the data from the Database Credentials of your Heroku Account (as in this other example):

Host : ec2-50-17-250-38.compute-1.amazonaws.com
Database : d5u8osf3cgtlg
User : seejtnnivrlcdw
Port : 5432
Password : e9ed17c73da7ec36bf6eead010968106439debe16ed3df9039be?????
URI : postgres://seejtnnivrlcdw:e9ed17c73da7ec36bf6eead010968106439debe16ed3df9039b???????
@ec2-50-17-250-38.compute-1.amazonaws.com:5432/d5u8osf3cgtlg
Heroku CLI : heroku pg:psql postgresql-trapezoidal-20780 --app jhipster-press-08