Google Code-in

Walk through http://try.github.io/ and find resources to learn how to do the following:

Clone the official PostgreSQL Git repository, and use the command line to clone the repository to your local machine. Then, proceed to install PostgreSQL via command line from source to your local machine. Finally, initialize a new database and create a table within the new database, inserting a single line of data.

Write a short summary of the commands executed to accomplish this, along with an explanation of the logic behind the commands chosen. Include a brief description of what the most challenging part of the task was, in addition to lessons learned.

Official documentation showing how to install PostgreSQL from source is found here: https://www.postgresql.org/docs/11/static/installation.html

Please note that PostgreSQL should be installed from the official Git repository, NOT the GitHub mirror. The Git repository can be found here: https://git.postgresql.org/gitweb/?p=postgresql.git with URLs in the upper left hand corner to reference for cloning the repo.