- datasource connection url<\/li>
- login<\/li>
- password<\/li><\/ul>\n\n\n\n
Setup our Application Configuration<\/h3>\n\n\n\n
Open up our
application.yaml<\/code> file and add this configuration, making sure to put your datasource url into the correct location. The format isjdbc:postgresql:\/\/${host}\/${database}<\/code><\/p>\n\n\n\n---<\/pre>\n\n\n\n
spring:\n profiles: herokudb\n datasource:\n hikari:\n connectionTimeout: 20000\n maximumPoolSize: 2\n url: jdbc:postgresql:\/\/ec2***.amazonaws.com:5432\/df***e<\/code><\/pre>\n\n\n\nWe\u2019re defining a spring profile here because we don\u2019t want to use this datasource by default. If we put it into the default profile, it will become visible to our tests and they will prefer postgreSQL to H2, which is not preferred. By putting the postgreSQL configuration into a separate profile, we can control when we connect to it.<\/p><\/blockquote>\n\n\n\n
We could put our username and password here, but that would be extremely unsafe and also problematic if we have several environments (dev, test, prod, etc\u2026). So for the meantime we\u2019re going to put that into our runtime configuration.<\/p>\n\n\n\n
Go into the
Edit Configurations\u2026<\/code> menu item on the run dropdown in intellij. Go into theConfiguration<\/code> tab of theMediumCustomerApplication <\/code>application. Expand the VM options section and add this configuration (replacing with your username and password)<\/p>\n\n\n\n-Dspring.profiles.active=herokudb\n-Dspring.datasource.username=amk***d\n-Dspring.datasource.password=2a***97c<\/code><\/pre>\n\n\n\nI also had to update my
pom.xml<\/code> in order to get it working:<\/p>\n\n\n\n<dependency>\n <groupId>org.postgresql<\/groupId>\n <artifactId>postgresql<\/artifactId>\n<\/dependency>\n<dependency>\n <groupId>org.liquibase<\/groupId>\n <artifactId>liquibase-core<\/artifactId>\n<\/dependency><\/code><\/pre>\n\n\n\nClick OK and then startup our application. We should see that it connected to our postgres database.<\/p>\n\n\n\n
2020-03-30 13:54:01.157 INFO [customer,,,] 7732 --- [ restartedMain] o.s.b.a.h2.H2ConsoleAutoConfiguration : H2 console available at '\/h2-console'. Database available at 'jdbc:postgresql:\/\/ec2****.amazonaws.com:5432\/df***e'<\/code><\/pre>\n\n\n\nLets confirm with the DB Browser. Click on the DB Browser tab under project on intellij<\/p>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/bullyrooks.com\/wp-content\/uploads\/2021\/02\/10HVv9pX_2zTPRVL61TJhJg.png?w=960\")
<\/figure>\n\n\n\nCreate a new connection to postgreSQL. Add your host information, username and password. Change the Database to the one supplied on the heroku datasource configuration page.<\/p>\n\n\n\n
<\/figure>\n\n\n\nWhen we test connection we should see a success. Now lets put some data in and make a request to confirm we can see the state of the database.<\/p>\n\n\n\n
Go ahead and use the postman POST statement we used to create a customer. Open up a DB browser window, change the database to
public<\/code> and execute this query:<\/p>\n\n\n\nselect * from customer;<\/code><\/pre>\n\n\n\nwe should see this data returned:<\/p>\n\n\n\n
<\/figure>\n\n\n\nOne thing to make note of here is that if we send the POST request in multiple times, we get different behavior. It appears that new records are allowed to be created in postgres. We will address this as we add validation to this service.<\/p>\n\n\n\n
Build and Commit<\/h3>\n\n\n\n
git checkout -b postgres\nmvn clean install\ngit add .\ngit commit -m \"Added postgreSQL configuration\"\ngit push --set-upstream origin postgres\ngit checkout master\ngit merge postgres\ngit push<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"