Now let us go ahead and download PostgreSQL on our systems.
So I'm using a windows PC.
So let's go ahead and learn how to download that step by step.
Go ahead and hit on downloads or go over here.
And one of them can go ahead here on downloads here.
Or go ahead and check that out.
So if you go ahead and hit on that you can see PostgreSQL downloads.
And I'll have packages and installers.
And here you have to select your operating system.
If you're using Linux you go for this.
For Mac OS you go for these windows, you go for these and so on.
Alright.
So every installation of all these are just similar.
I'll go ahead and hit on windows and then I'll get over to Windows Installer.
So Interactive Installer by EDB.
What I need is installer.
Go ahead and hit on installer.
And there once you do that you go ahead and see download PostgreSQL.
And then you can go ahead and then load PostgreSQL.
So you can see PostgreSQL Versions 17.0.
And when you go down, you can see so many of them.
I'm using windows 64 bit system and it is supported.
But for windows 32 it can say that these versions are not supported until you get down to 10.23.
Then if you're using windows 64 bit system core head and download 17.0.
So go ahead and hit on download.
And then we go ahead and start immediately.
And it says your download should begin in few seconds.
And our download have started.
And that is it.
So let's go ahead and check it out.
Over here I have my download.
You can see PostgreSQL 17.0.
Uh that is for 64 bit system our head and double click on that.
Or you can see that that is getting started.
And now very soon it should begin immediately to install.
Welcome to the PostgreSQL setup wizard.
Go ahead and hit on next.
And uh I'm going to choose that spot because I don't have any parts.
I have deleted every other Everyone wants to have.
I'll go ahead and hit on next.
And over here you can see the PostgreSQL server which is this very first one here.
That is the database server.
And then the Pgadmin is the graphical interface for managing and working with PostgreSQL database and
servers.
Then we have the stack builder.
And the stack builder is used to download and install additional tools, drivers and applications to
complement your PostgreSQL installation.
Then we have the command line.
And this is just command line tools and the client libraries and everything is listed for you.
Then go ahead and hit on next because we're going to select everything is shut out.
Everything is selected.
And I had hit on next, then our estimate then the path and go ahead and hit on next.
And now you are required to insert a password.
And this password you have to always remember this password.
All right.
So ensure that you have this password set somewhere because you're going to use that for your database
connection.
I'll go ahead and put a simple password and which I will always remember.
And uh for the purpose of this lecture Then go ahead and click on next.
And I'm going to still maintain the pots to be five, four three, two.
That is always the default for PostgreSQL.
Go ahead and hit on next.
And I'm going to still maintain the default AE.
I'll go ahead and hit on next, and I'll hit on next.
And the setup is now ready to begin installing PostgreSQL on your computer.
Go ahead and hit on next.
And now you can see that the installation is almost getting up.
And very soon we have PostgreSQL installed on a computer.
So let's sit back, wait for this and expect it to install successfully, and then we'll kick off immediately.
All right.
So it's almost getting there.
And very soon it will get to the end.
And we'll go ahead and conclude everything as soon as possible.
All right.
That has just completed.
And uh, it says that Buddha may be used to download and install additional tools, drivers and applications
to complement your PostgreSQL.
Uh, don't just want to do this one.
Now go ahead and save.
This setup has finished.
I'll just go ahead and hit on finished.
Unfinished.
And that is it for now.
So let's go ahead and move over to over here and go to applications.
And I'm using Windows 11.
So you can always go to application or app.
And then you scroll down and go down and check for PostgreSQL.
And you can see how PostgreSQL 17 go ahead and hit on this.
You open it up and you can see we have the Pgadmin right in here we have the application stack view,
we have the installation notes, the pgadmin documentations and the PostgreSQL documentations.
And cool.
And we also have the SQL shell.
Very important.
Go ahead and hit and hit on this.
And this is what we have.
We're going to learn in the next video lecture.
But go ahead and hit on enter.
You can see server database ports 5432.
And Helen says the name and password and the password and so on.
When I was showing us on how to connect all these in the next video.
So go ahead and check it out right now and close that.
And I'm going to see you in the next video lecture.