In this video, learn how to install Postgres.
- [Instructor] It's time to install our database. We'll be using PostgreSQL, which is also called Postgre. Let's start at the Postgre 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 Postgre 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 a 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 Postgre package is downloaded, I'll open it and start the installation. And I'll see the Postgre 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, you're steps may be slightly different, but the same general idea should apply. Okay, I'm going to select next from the start up wizard. And I'm going to select all of the default options so that'll install Postgre for me and it will also install pgadmin, 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 Postgre, 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 seeing similar things if you don't have Postgre 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 pgadmin. If you already have Postgre installed and you're updating, you may see a message similar to that as well. And okay the set up wizard is complete. Now you have the option of installing some additional Postgre 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 Postgre installed. In the next video, we'll take a look at pgadmin.
- How SQL executes queries
- Working with PostgreSQL tools for tuning
- Bitmap and hash indexes
- Using different types of indexes to improve performance
- Challenges with joining tables
- When to use partitioning to improve performance
- Collecting statistics about data in tables