From the course: Advanced SQL for Data Science: Time Series

Installing PostgreSQL - SQL Tutorial

From the course: Advanced SQL for Data Science: Time Series

Start my 1-month free trial

Installing PostgreSQL

“

- [Instructor] It's time to install our database. We'll be using PostgreSQL, which is also called Postgres. Let's start at the Postgres download page. That's located at https://www.postgresql.org/download. There are options for a number of different operating systems. I'm working on a Mac, so I'll select a link for that option. There are several ways to install Postgres on a Mac, and I'm going to use the EnterpriseDB interactive installer. It's easy to use and is available for Mac, Windows, and Linux operating systems. I'll just click on the Download the Installer and now I'll choose the version that I'm interested in. I want to use the latest version, which is 11.1, which is available for Mac and Windows at the time of this recording. So I'll click Download, and it'll start downloading the image for me. Now, if you're using Windows, you can select the Windows option appropriate for your version of the operating system. Okay, now that the Postgres package is downloaded, I'll open it and start the installation. And I'll see the Postgres installer here, and I'll double click on that. And I get a security warning here, but I'm going to continue. And I'll enter my password so I can install this software. Now, on Windows or Linux, your steps may be slightly different, but the same general idea should apply. Okay, I'm going to select Next from the startup wizard. And I'm going to select all of the default options so that'll install Postgres for me, and it will also install PG Admin, which is a tool we'll be using for executing queries and navigating our way around our various tables and other data structures. Now, you'll notice I already have an existing installation of Postgres, so it's just going to upgrade for me. And similarly, I already have some data stored on the disk, so that data directory will be used for this installation. And now, at this point, we should be saying similar things, if you don't have Postgres already installed, you'll get a pre-installation summary like this. And we'll just click Next, and Next one more time. And that'll execute the installation process. You may have noticed that I received a message about closing PG Admin. If you already have Postgres installed and you're updating, you may see a message similar to that as well And okay, the setup wizard is complete. Now you have the option of installing some additional Postgres tools using something called Stack Builder. We don't need any additional tools, so I'm going to uncheck that box and click Finish. And that's it, we have Postgres installed. In the next video, we'll take a look at PG Admin.

Contents