PostgreSQL & Docker - Creating a Dockerfile & Connecting
Your first step will be to install Docker. After, create a new Dockerfile that will install PostgreSQL and run a PostgreSQL database server on your local machine or VM. Run the newly created container in the foreground, and connect from your host system to test the database server connection using psql. Create two tables and insert some sample data.
The expected submission will be a document explaining the steps taken along with screenshots illustrating your progress, in addition to the output from commands to display the table list in the created database and a query to display all inserted data for the created tables. It should also include a listing of the created Docker image using Docker commands, as well as evidence that it was an active process on the system.
In addition to the document, please submit the created or used Dockerfile.