dlbunker/ps-first-spring-boot-app

Pluralsight Spring Boot Application Resources

Author: Dan Bunker

ps-first-spring-boot-app's Issues

Stopping docker container README command typo

"docker start postgres-demo" needs to be "docker stop postgres-demo"

Bump postgres:11.5-alpine to postgres:11.10-alpine

postgres:11.5-alpine is not available anymore: https://hub.docker.com/_/postgres

Readme needs a note about needing to copy *.sql files to local

Think it might be good to add a note that the *.sql file first needs to be copied into local machine before executing the docker cp command :)...i initially just ran the docker cp like it was mentioned in the readme and it did not show any error . But then when i went to pgadmin4 and viewed the database, i did not find any tables or data.

Then cloned your repo to local and executed this below command and then it worked (i have docker for windows).

docker cp ./ps-first-spring-boot-app/database/postgresql/create_tables.sql postgres-demo:/create_tables.sql

docker cp ./ps-first-spring-boot-app/database/postgresql/insert_data.sql postgres-demo:/insert_data.sql

FATAL: password authentication failed for user "postgres"

It wasnt working but then after updating docker "magically" started to work.

Readme - Application Database Setup

I found that I had to use the following commands to setup the database after starting the docker container on my windows system:
docker exec -it containerid /bin/bash
createdb -U postgres conference_app
psql -U postgres -d conference_app -f create_tables.sql
psql -U postgres -d conference_app -f insert_data.sql

Update readme with run from docker

update readme with run from docker as:
docker exec -it postgres-demo psql -U postgres

Readme - Docker create command

Suggest to change command line:

docker create --name postgres-demo -e POSTGRES_PASSWORD=Welcome -p 5432:5432 postgres:11.5-alpine

into:

docker create --name postgres-demo -e POSTGRES_PASSWORD=Welcome -p 5432 postgres:11.5-alpine

If you run the docker create command with 5432:5432 and then type

docker start postgres-demo

will give the following error message on Linux Mint 19.1:

Error response from daemon: driver failed programming external connectivity on endpoint postgres-demo (91725e72a055c90304ae19f52e5b78cbdbb4a979c341863e19e35045aa938452): Error starting userland proxy: listen tcp 0.0.0.0:5432: bind: address already in use
Error: failed to start containers: postgres-demo

Postgres Course Setup Steps are Unclear

Hi, I am trying to follow along with your pluralsight course https://app.pluralsight.com/library/courses/creating-first-spring-boot-application. I am getting stuck on setting up the postgres db.

For example, creating the the image for the postgres db and starting it stopping it is clear but what do I do with the connection info, where is that used? also the commands are not in order of how someone would execute them to get the db set up and running for the course.

Also under "Application Data Setup" - where are those commands supposed to be executed? inside the postgres cli? outside in a terminal or a shell?

You also just gloss over this big and important step in your pluralsight course even though this course is listed as beginner on pluralsight. In your course videos you do not go over how to install and setup docker or a local postgres instance or how to create and install data in tables as well. I know you might say the focus of this course is not to know docker or postgres since we are talking about spring boot but it seems like a big oversight since use those two technologies to set up your spring boot application.

Would like some clarification of these steps for myself and for future viewers of your course.

Thank you!