So let's get Postgres installed on windows, so I'm on the site where I find the window installers,
which the URL is right here, PostgreSQL, Duggie, download Windows and I will just click the download
the installer link right here.
And I'm on Windows and I want 64 bit windows, and you almost certainly do as well.
It's unlikely you have a 32 bit system, but if you do just download this version right here, which
is an older version but will still work for this course.
So I'll download the 64 bit installer for Windows and it should start downloading.
And there it goes.
And I'll open the file.
And yes, I'll allow this.
And it should take me through a wizard to install everything.
And here we go.
So next.
And I'll take the default installation director and I will allow postgrads to be installed.
I'm not going to bother with PJI admin for because it does too much.
I'm not going to bother with the stack builder, but I'll keep going and I'll take the default data
directory.
And now this part.
Do not forget this password I'm going to put in my own, which will just be password.
You need to remember this password and the user is Postgres so the user is postgrads and the password
is password next and the port is the default port five, four, three, two.
And I'll use the default.
Lacau And next.
And now it will install everything which can take a little while.
All right, so it looks like it's installed now, let's just see what's in here.
So I'm going to search for Postgres and we have Postgres system software.
OK.
The documentation, that's the installer, I don't want to start that again.
No, so I'll just cancel it, let's just see what happens.
So it may be running, I have no idea.
I haven't read the documentation yet, but I'll go back to my Web browser and I will now go over to
Deaver and let's download Deaver.
And again, it's just Beavertail.
I'm going to download the version for Windows.
I want the community edition 64 bit installer, and this will be the client we're going to use to install
or to connect to our database locally.
And I'm not sure if it's running yet because I don't use windows that often, but we'll figure it out.
So Deaver's downloaded Let's Open the Installer.
And I will use English.
And I will choose next, and I agree to the terms and conditions, I'll allow anyone to use it, since
there's only one account that's not really an issue.
Yes.
And it should fire up the installer or install it here for a shortly.
OK, apparently I have to do this twice next, I agree, and we want that's all we want next.
And next and next.
Not sure why we had to do that twice, but I'm sure they had some reason when they put their installer
together.
All right, let's create a desktop shortcut so I can find it, and there it is.
So let's start it up and see if our database is actually running.
If not, we'll have to figure out how to start it.
Allow access.
OK, let's see if we can connect.
Do you want to create a sample database that can be used?
As you know, I don't want to create a sample database.
All right.
Select my database.
My database is going to be Postgres right here next.
And download the necessary files, so it goes and gets the necessary drivers for those and let's see
if this works.
So localhost is the host, postgrads is the database.
There should be one called postgrads.
Five, four, three, two is the correct port.
And here's where I put in my password, which I set to password and let's say finish and see what happens.
It looks like we are connected, perfect, and that's how you connect to the database, so that takes
care of the installation for Windows.
Let's move on.