You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing firstname.lastname@example.org.
We are experiencing playback issues from our video hosting provider. Please check back shortly.
This lesson is part of the Databases in Ignition course. You can browse the rest of the lessons below.
6:39Connecting to MySQL
5:56Connecting to Microsoft SQL Server Express
5:11Creating a SQLite Connection
Take topic challenge
Take topic challenge
See a walk-through of downloading and installing PostgreSQL Server.
Video recorded using: Ignition 8.1
Transcript(open in window)
[00:00] In this lesson, we'll install PostgreSQL. To begin with, we'll need an installer. In my browser here, I'm looking postgresql.org. We'll head over to their downloads page. We'll select our operating system. And they provide us a lovely table, with supported versions and platforms. From here, I can download the installer, or download a zip archive full of binaries. I'm going to take the graphical approach here and download the installer, which I have already done, so I'll close my browser here. And I'll go ahead and run this installer. All right. And here we are in the wizard. I'll go ahead and click Next to get started. I'll use the default installation directory. And here are the things that this installer is going to install. Now, really, we only need two things. We need the server, and then we need this pgAdmin 4. These two things are gonna be pretty useful for us.
[01:03] These other tools, I'll go ahead and leave there, and click Next. I'll use the default data directory. I'll click Next again. Now for the database server, there's going to be a super user, named Postgres. We need to give that user a password. So go ahead and type in something that you'll remember. And again, this is to kind of help us administrate the database server later on. I'll click Next. I'll use the default port. And I'll use the default locale. Here's all the stuff it's gonna do, I'll click Next. And we'll let the installer run. All right. And that finishes the installation portion. We can go ahead and finish, before we do, I'm going to uncheck this launch stack builder. Don't actually need it to open at the end here, but we can, you can always play around with that later, if you like. I'm gonna click Finish. Now, technically we have the database running on the local system here, so we could go ahead and start connecting to Ignition. But before we do, there's one little thing I would like to do, which is create an Ignition database, for Ignition to connect to later on.
[02:06] PostgreSQL is a database server, which can have multiple databases inside of it. So we're going to create one specifically for Ignition to use later on, which is a, generally speaking, a good practice. Now you can do this through the command line, but you can also use that pgAdmin tool, I was talking about earlier. So the next step is to find pgAdmin. If you installed on Linux, pgAdmin is available under programming, in the application menu. On Mac, it's available in the applications folder, as an application. And on Windows, if you open up the start menu. Look down your list of programs here. Under postgres here, you should have pgadmin 4, which I'll go ahead and launch. All right. So when pgAdmin opens, it's likely going to prompt you about a master password. Now, in my case, it's asking me to enter the master password, but in your case, it might be asking you to create the master password. So this master password is different than the password we created earlier during the installation.
[03:05] This is specifically for pgAdmin. So again, pgAdmin is a separate program from the database server we installed. So, go ahead and type in a password, again, something you'll remember. In my case, I just need to type in the password I typed in earlier. And I'll click Okay. And once you're here, we can actually go ahead and browse our servers, in the upper left-hand corner here. By default, when you install Postgres, it will go ahead and add an entry for whatever Postgres version you installed. So this PostgreSQL 13 here, is the one I just installed. So let's go ahead and enter the password. And this is for the Postgres user. This is the user we created during the installation. Not the pgAdmin password we just typed a moment ago. I'll click Okay. And we're now connected to the local database server. So, Postgres is a database server, which can have multiple databases inside of it. By default, it does create this Postgres database, that we can start creating tables and running queries against, but let's create our own.
[04:05] So I'm going to collapse that. I'm going to right-click on Databases. I'm going to hit Create database. I'll type in Ignition. The name we type in here, we'll need to remember for later on, because when we try to connect Ignition to a database inside of Postgres, we'll need the name of that database. I'll leave the other options alone, and I'll click Save. And if we look in the upper left-hand corner, we can see that there is this Ignition database. If I click on it. Just took a moment there to refresh. We can see it's now up and running. And we're connected to it with pgAdmin 4. Cool. So now we have this other Ignition database we can connect to, which means we're ready to go ahead and move to the connecting video. So in the next video, we'll create a database connection from Ignition, to this Ignition database we just created inside of Postgres.