Our next step is to install pgAdmin, which is the graphical user interface that we will be using to interact with postgreSQL in this course.Īs before, the easiest way to start your download of pgAdmin is by running a Google search for pgadmin. You can click Next here and then Next on the Ready to Install page to begin the installation! Step 3: Download PgAdmin We will leave this as its default value of. The last step in this installation is to specify the locale to be used by the new database cluster. It is fine to leave this value as whatever it pre-populates as. The port number will specify 5433 if you have never installed postgreSQL before although it may show up as 5432 depending on your computer's configuration. Once your password has been specified, the postgreSQL wizard will ask you which port you'd like to use. Because of this, be sure to note your password somewhere safe. If you ever forget this password, you will need to uninstall and reinstall everything related to postgreSQL. This is where you specify your password for your postgreSQL database. Once again, it is fine to use the default directory. The next page will ask you to specify a data directory. Click Next to proceed through the installation process. It is fine to include all of these components. Next, the wizard will ask which components you'd like to install along with postgreSQL, including the following elements: It is fine to use the default installation directory in our case. This will open the postgreSQL setup wizard, which will ask you to specify an installation directory. Once the file is done being unzipped, a new window will open that looks like this:ĭouble-click on the postgresql-12.2-3-osx file to start the installation process. You will see a file with a title similar to. We have downloaded the necessary postgreSQL files to our computer, and now we need to install them. In my case, this is postgreSQL 12.2, as circled below: In general, you'll usually want to download the most recent postgreSQL distribution that is available on your operating system. The next screen presents a grid of the different versions of postgreSQL that are available along with their compatibility with different operating systems. Accordingly, click on the link specified in the image below: We will be using the interactive installer by EnterpriseDB. The next screen has instructions for how to install postgreSQL. If you are a Windows user, click Windows. This will take you to another page where it asks you to specify which postgreSQL distribution you'd like: MacOS, Windows, Linux, or something else. Once you have navigated to the postgreSQL website, click the large Download button at the top of the screen. The first result is the one we're looking for. To download postgreSQL, the easiest first step is to head over to Google and search for postgreSQL: With that out of the way, let's start the process of installing our software! Step 1: Download PostgreSQL Do not forget your PostgreSQL password! Unlike many passwords we encounter in our day-to-day digital lives, there are no easy ways to reset the password for your database.We will be interacting with this file using the PgAdmin software we'll download later. Do not open the dvdrental file directly using your Finder application.Accordingly, I wanted to point out these errors from the start so that you know what not to do: People often make two small errors while downloading PostgreSQL that will force them to restart this tutorial from the very beginning. Note that while I designed this tutorial from the perspective of a Mac user, it should be very similar for people working through this course on a Windows operating system. PgAdmin - a graphical user interface for connecting to PostgreSQL and submitting queries.PostgreSQL - the actual SQL engine that we use to store data.In this lesson, we will work through the installations and configurations necessary for you to work through this course.
0 Comments
Leave a Reply. |